MySQL Workbench Migration Invalid Column Name for some tables
Posted by: Terence Silonda
Date: February 22, 2013 05:55AM

I've been trying to Migrate from SQL Server to MySQL.

I've only partly succeeded. While some tables were created and data copied, some were only created but the data not copied.

I checked the logs, and for those tables the error was below, this was for each column in a particular table.

2207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'OrderID'.

Am I missing something?

Please note, some of the tables hold as many as 40,000+ rows, some 6 or so.

Any help will be appreciated.

Options: ReplyQuote

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.