MySQL Forums
Forum List  »  Microsoft SQL Server

MS SQL to MySQL migration fails with no columns detected
Posted by: Pallav Saikia
Date: May 14, 2007 08:57PM

Trying to migrate my database from MS SQL Express 9.0 to MySQL 5. I am trying to do it using MySQL Migration toolkit 1.1.11. The toolkit fails to pickup any columns from MS SQL, it picks only blank table definitions like the following:

-------------
DROP TABLE IF EXISTS `xobdo_devDB_xobdo_dblogin`.`gender_types`;
CREATE TABLE `xobdo_devDB_xobdo_dblogin`.`gender_types`
)
ENGINE = INNODB;
-------------

Similarly at the bulk data transfer step also, its picking up blank select clause:

-------------
Transfering data from table gender_types (6/6 rows)
SELECT FROM "xobdo_dblogin"."gender_types"


ERROR: The following error occured while transfering data from gender_types
Incorrect syntax near the keyword 'FROM'.
------------

Tried using Navicat too, but it also fails. Its not even showing me the list of tables after odbc connection gets setup.

Please help. Thanks..

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.