[ n a t a s a @ 11.02.2010. 13:56 ] @
Kako je najlakse prebaciti podatke iz baze MSSQL u MySQL?
Mogu da napisem program koji ce to da radi...
Da li postoji neki laksi nacin?

Hvala!
[ bogdan.kecman @ 12.02.2010. 12:02 ] @
http://dev.mysql.com/doc/migration-toolkit/en/index.html
http://dev.mysql.com/tech-reso.../migrating-from-microsoft.html

Citat:

There are a wide variety of tools available to help you migrate a SQL Server or Access database to MySQL. We'll look at several different tools so you can choose the one that best suits your needs. The tools we will look at will include the following:

* MSSQL2MYSQL
* Microsoft DTS
* SQLyog
* Access Export
* Text Import/Export

SQLYog and the Microsoft DTS wizard offer graphical interfaces that can be used with both MSSQL and Microsoft Access to import tables into MySQL. MSSQL2MYSQL is a script by Michael Kofler that can convert not only the table structure and data, but converts the index information as well. If you use Microsoft Access you may not have access to the above tools, but you can use the data export features of Access.
[ MarkoBalkan @ 12.02.2010. 19:22 ] @
ETL

http://en.wikipedia.org/wiki/Extract,_transform,_load

Pentaho -> open source tools.
[ n a t a s a @ 15.02.2010. 16:04 ] @
Hvala! Ali imam jos jedno pitanje...

Imam problem kad u MySQL Migration Tool hocu da izvrsim migraciju sa SQL Servera na MySql prijavljuje mi gresku:

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection Dsn=barcode;UID=appTo;PWD=djura
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :No suitable driver
Details:
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(ReverseEngineeringMssql.java:99)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)



Da li je neko imao slican problem?
Googlala sam,ali nista korisno nisam uspela sa nadjem.

Kad vrsim migraciju sa Access-a na Mysql bez problema radi.

Hvala unapred!
[ MarkoBalkan @ 17.02.2010. 15:12 ] @
Citat:
n a t a s a
ReverseEngineeringMssql.getSchemata :No suitable driver
Details:
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:141)
com.mysql.grt.modules.ReverseEngineeringMssql.getSchemata(ReverseEngineeringMssql.java:99)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)



piše ti, ovo boldano.

nemaš java drivera za sql server.