Problem in migration from MS SQL to MySQL ,using MySQL Migration toolkit
Posted by: Ranjeet Singh
Date: June 23, 2009 04:45AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Problem in migration from MS SQL to MySQL ,using MySQL Migration toolkit
June 23, 2009 04:45AM


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.