C# .NET - MYSQL TO SQL SERVER 2008 - Asked By Ismael on 28-Feb-12 01:58 PM

Hello I have a databas in MYSQL, but now I want to use MSQLServer. How can I transfer all the tables and data?
kalpana aparnathi replied to Ismael on 28-Feb-12 02:02 PM
hi

This video covers the process of moving data from MySQL to SQL Server 2008 once the database structure has been migrated.  :http://blogs.msdn.com/b/ssma/archive/2010/10/14/mysql-to-sql-server-2008-migration-workshop-video.aspx

Regards,
Sreekumar P replied to Ismael on 28-Feb-12 02:30 PM
Hi,

GO here :

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=69739c8c-ac82-41de-b9e6-8fa5ae2594d9&displaylang=en

Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.

dipa ahuja replied to Ismael on 29-Feb-12 01:02 AM
Check this migration tool

http://technet.microsoft.com/en-us/library/cc966396.aspx 
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html 

Somesh Yadav replied to Ismael on 29-Feb-12 07:18 AM

See http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx. The idea is to add your MySQL database as a linked server in SQL Server via the MySQL ODBC driver. Then you can perform any operations you like on the MySQL database via SSMS, including copying data into SQL Server.

Congrats on moving up in the RDBMS world!

Ismael replied to Somesh Yadav on 29-Feb-12 01:15 PM
lol