Importing a MySQL Database to SQL Server 2008
We're moving from MySQL to SQL Server 2008. What is the best way to move over table structure, indexes, foreign keys and data? I tried the Import and Export Data Wizard with the driver for MySQL ODBC and MySQL ADO.Net but it wouldn't let me move tables it would only let me write a sql statement, no primary key, no indexes etc. I'd hate to have to add all those foreign keys back in by hand.
January 28th, 2011 3:34pm

Hello, I don't think so you can move the object from MYsql to SQL Server. You have to generate script from MYSQL and then run on SQL. You might have to make changes in scripts to run on SQL Server. After creating objects then move the data from MYSQL to SQL Server as you said you are able to do that. ThanksAamir
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2011 3:43pm

Aamir is right , but there is another non-SSIS way too, use third party database converters . there are lots of converters which convert existing mysql database to sql server, I hadn't such experience before , But I think you will get good result with a simple test on them. with a simple googling I found these links: http://www.spectralcore.com/fullconvert/tutorials/convert-mysql-to-mssql-sql-server.php http://www.convertmydatabase.com/http://www.rad.pasfu.com
January 28th, 2011 3:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics