C# .NET - How to export MySQL database to use in MSSQL

Asked By Tejaswini Prashant J on 15-Jan-10 12:13 AM

Hi
Can anybody tell me the process how I can export MySQL database to use in MSSQL.
Those have done this ..plz reply me in detail


Require third party tool - EMS MySQL Utils 1.7 - Kalit Sikka replied to Tejaswini Prashant J on 15-Jan-10 12:27 AM

Require third party tool - EMS MySQL Utils 1.7

http://serw.clicksor.com/newServing/go.php?nid=1&cpx=cpc&uid=201475072&pid=98614&sid=145755&spid=0&af=0&rf=0&kw=mysql&curl=http%3A%2F%2F6702.gotitsearch.com%2Fxtr_new%3Fq%3Dmysql%26enk%3DxoEnoSepB%2BOG4ybjhpmGsebjJpHGmaaZZpEmiQ%3D%3D Utils are powerful data management utilities forMySQL Server, which make your work with the server much easier and faster. MySQL Utils include powerful utilities for comparing MySQL databases and discovering differences in their structure, building and executing queries, converting ADO-compatible databases to MySQL, quick exporting and importing data from/to MySQL tables and extracting data and metadata.

http://import-export-mysql-to-ms-sql.downloadsoftware4free.com/

MySql to SQL Server - F Cali replied to Tejaswini Prashant J on 15-Jan-10 12:29 AM

Here's a link that discusses how to migrate your MySQL database to SQL Server:

http://studentclub.ro/lucians_weblog/archive/2007/04/30/migrate-from-mysql-to-ms-sql-server-2005-express-edition.aspx

http://technet.microsoft.com/en-us/library/cc966396.aspx

Regards,
http://www.sql-server-helper.com/error-messages/msg-1-500.aspx

MySQL to SQL Server - mv ark replied to Tejaswini Prashant J on 15-Jan-10 12:33 AM

Depending on whether you are using SQL Server 2000 or 2005, you can use either Data Transformation Services (DTS) or SQL Server Integration Service (SSIS)

These detailed articles explain the process -
http://technet.microsoft.com/en-us/library/cc966396.aspx
http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf5350e/MigrateMySQLtoSQLServer.docx
export MySQL database to use in MSSQL - Sagar P replied to Tejaswini Prashant J on 15-Jan-10 12:43 AM

You need to use the http://dev.mysql.com/downloads/connector/odbc/3.51.html (be sure to download the appropriate version for your MySQL Database; the link is for version 3.51) to create a Linked Server to the MySQL Server, and then run a SQL query to copy your database, table by table. The query is (write the database name, server name, user and password specific to your server):

EXEC master.dbo.sp_addlinkedserver @server = N'MYSQL', @srvproduct=N'MySQL', @provider=N'MSDASQL', @provstr=N'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=127.0.0.1; DATABASE=Db_NAME; USER=myusername; PASSWORD=mypass; OPTION=3'

 

Then you’ll have to copy your database table by table. The code for one of the tables will be:


select * into MSSQL_DB_Name.dbo.TableName

from openquery(MySQL, 'select * from Db_Name.TableName')

 

http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx

 

http://studentclub.ro/lucians_weblog/archive/2007/04/30/migrate-from-mysql-to-ms-sql-server-2005-express-edition.aspx

 

http://technet.microsoft.com/en-us/library/cc966396.aspx