restore mySQL on SQL server

[Steel811]

Hello,

Is there a way to restore a mySQL database dump file onto a SQL server 2005 database? I assume the database I'm restoring needs to be created, but the steps to restore the backup, I'm not sure.

Thanks,
Sheel

 

[Steel811]

Hello everyone,

After doing further research, it is not possible to simply copy the database dump into a query analyzer on SQL 2005. A conversion software appears to be required. Here's one I found:

http://www.convert-in.com/sql2mss.htm

Thanks anyways,
Sheel

 

[ESquared]

Or use SSIS to get the data & structure out of the MySQL database in the first place.

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]