Problem in migration from MS SQL to MySQL ,using MySQL Migration toolkit

[Ranjeet Singh]

Hi all, I am trying to migrate from MS SQL Server 2000 to MySQL 5.x.

I have selected two tables from the database collegesnaps named MaxCount and NationalHolidays for migration.

here is the Message log of the 5th step




Initializing JDBC driver ...
Driver class MySQL JDBC Driver 5.0
Opening connection ...
Connection jdbc:jtds:sqlserver://127.0.0.1;user=sa;password=sa;namedPipe=true

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

SET FOREIGN_KEY_CHECKS = 0
An error occured while executing the SQL statement.
Line 6: Incorrect syntax near '='.
Creating schema collegesnaps_dbo ...
CREATE DATABASE IF NOT EXISTS collegesnapsmysql CHARACTER SET latin1 COLLATE latin1_swedish_ci
An error occured while executing the SQL statement.
Incorrect syntax near the keyword 'IF'.
Creating tables ...

Creating table MaxCount ...
DROP TABLE IF EXISTS collegesnapsmysql.MaxCount
An error occured while executing the SQL statement.
Incorrect syntax near the keyword 'IF'.

Creating table NationalHolidays ...
DROP TABLE IF EXISTS collegesnapsmysql.NationalHolidays
An error occured while executing the SQL statement.
Incorrect syntax near the keyword 'IF'.
Creating views ...
Creating procedures ...

Execute script footer commands.
SET FOREIGN_KEY_CHECKS = 1
An error occured while executing the SQL statement.
Line 1: Incorrect syntax near '='.




Please tell me where I am going wrong.
How to correct this.



Edited 1 time(s). Last edit at 06/23/2009 04:56AM by Ranjeet Singh.