MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Exporting MYSQL to MSSQL
Posted by: Jesus Williams
Date: October 31, 2005 11:37AM

yes, DTS is unable to read the schema from some foreign databases. it could be a limitation of the particular ODBC driver. select statements should work through regular ODBC/JDBC connection to the MySQL server. Beyond that, the DTS stuff doesn't understand how to get a schema from the foreign driver and therefore fails.

what you need to do is create the schema manually on the SQL server and then do the replication using the Import/Export wizard using the "SQL query method" of getting the rows from the mySQL db.

Options: ReplyQuote

Written By
September 05, 2005 06:20AM
Re: Exporting MYSQL to MSSQL
October 31, 2005 11:37AM
November 21, 2005 09:24AM

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.