Re: exporting MySQL database to SQL database
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.
Subject
Written By
Posted
December 13, 2005 07:31AM
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.