MySQL Forums
Forum List  »  Microsoft SQL Server

Re: exporting MySQL database to SQL database
Posted by: Roland Bouman
Date: December 13, 2005 07:41PM

I think that this is best done using a DTS package.

Open your MSSQL enterprise manager, create a target database on MSSQL,
then open the Data Transformation Services node, and click Local packages.

From there, you can drag n drop a simple one to one import package. You need to install the MySQL odbc driver on the mysql side, use that as source, and use the MSSQL target as target.

Options: ReplyQuote

Written By
Re: exporting MySQL database to SQL database
December 13, 2005 07:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.