MS SQL to MySQL migration fails with no columns detected
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..
Subject
Written By
Posted
MS SQL to MySQL migration fails with no columns detected
May 14, 2007 08:57PM
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.