Re: Exporting MYSQL to MSSQL

[Jesus Williams]

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.