Importing data from MS SQL to MySQL

[killersites]

HI,

I need to move a database from SQL server 7 to MySQL. The database has to be moved in such a way that the relationships are kept in tack so that the application that depends on the data’s integrity does not fall apart.

I’ve tried using SQL Server’s DTS wizards but thus far I have had only partial success. That being said does your product make it easier to move databases over than DTS?

Question #2:

I have the scripts ready to build a mirror of the SQL Server database in MySQL, could I then use your product to move the data? Or would I be better off to have your product build the database from scratch during the import/migration procedure?

Thanks,

[peterlaursen]

I won't answer the question – have no experience with MSSQL

but are you aware of the Migration toolkit from MySQL ?

http://dev.mysql.com/downloads/migration-t…oolkit/1.0.html

[killersites]

peterlaursen wrote on Mar 5 2005, 08:11 PM:

I won't answer the question – have no experience with MSSQL

but are you aware of the Migration toolkit from MySQL ?

http://dev.mysql.com/downloads/migration-t…oolkit/1.0.html

Hi,

I was not aware of this tool – I'll have to look into it.

Thanks,

Stefan

[Ritesh]

Quote:

That being said does your product make it easier to move databases over than DTS?

Yes. SQLyog's ODBC Import Tool is what you require.

Quote:

I have the scripts ready to build a mirror of the SQL Server database in MySQL, could I then use your product to move the data? Or would I be better off to have your product build the database from scratch during the import/migration procedure?

It depends. I think that SQLyog ODBC Import wizard will be a better option as the scripts might not be MySQL compatible. If you are sure that the scripts are indeed MySQL compatible then they are a better option.

[Author]

Posts