[es] - Kako prebaciti podatke iz MSSQL u MySql?

n a t a s a
beograd

Član broj: 250925
Poruke: 12
*.dynamic.sbb.rs.

Profil

Kako prebaciti podatke iz MSSQL u MySql?

^{11.02.2010. u 13:56 - pre 172 meseci}

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!

Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.31.24.217.adsl2.beograd.com.

Sajt: mysql.rs

+2377 Profil

Re: Kako prebaciti podatke iz MSSQL u MySql?

^{12.02.2010. u 12:02 - pre 172 meseci}

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.

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Odgovor na temu

MarkoBalkan

Član broj: 141124
Poruke: 1624
..141.115-dsl.net.metronet.hr.

+19 Profil

Re: Kako prebaciti podatke iz MSSQL u MySql?

^{12.02.2010. u 19:22 - pre 172 meseci}

ETL

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

Pentaho -> open source tools.

Odgovor na temu

n a t a s a
beograd

Član broj: 250925
Poruke: 12
*.dynamic.sbb.rs.

Profil

Re: Kako prebaciti podatke iz MSSQL u MySql?

^{15.02.2010. u 16:04 - pre 172 meseci}

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!

Odgovor na temu

MarkoBalkan

Član broj: 141124
Poruke: 1624
..139.107-dsl.net.metronet.hr.

+19 Profil

Re: Kako prebaciti podatke iz MSSQL u MySql?

^{17.02.2010. u 15:12 - pre 172 meseci}

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.

Odgovor na temu