Database Migration -- Microsoft SQL Server 2008 - MySQL 5.5.20

[santhosh kumar]

Hi,

I recently download the lastest version of MySQL Migration Toolkit to migrate a Microsoft SQL Server 2008 database to a MySQL 5.5.20 database.

I was able to connect to both the source and the target databases. The schema/database was also created in the MySQL database.

I am trying to migrate the tables in the Microsoft SQL database and the table creation script throws an error. The 5th step of the Migration process (Schema Creation), when I clicked on Advanced, I see the following error message for the the table creation script.

---------------------------------------------------------
Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:mysql://10.6.162.26:3306/?user=xxxxxx&password=xxxxxxxxxx&useServerPrepStmts=false&characterEncoding=UTF-8

Execute script header commands.
-- ----------------------------------------------------------------------
-- MySQL GRT Application
-- SQL Script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0
Creating schema TEST_DATABASE ...
CREATE DATABASE IF NOT EXISTS `TEST_DATABASE`
CHARACTER SET latin1 COLLATE latin1_swedish_ci
Creating schema TEST_DATABASE ...

USE `TEST_DATABASE`
Creating tables ...

Creating table BRAND ...
DROP TABLE IF EXISTS `TEST_DATABASE`.`BRAND`
Creating table BRAND ...

CREATE TABLE `TEST_DATABASE`.`BRAND`
)
ENGINE = INNODB
An error occured while executing the SQL statement.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ENGINE = INNODB' at line 2

--------------------------------------------------------------

The MySQL Migration Toolkit is not generating the create table scripts correctly. Pleae let me know how I can correct this error.

Any help will be greatly appreciated.



Edited 1 time(s). Last edit at 03/09/2012 04:43PM by santhosh kumar.