hi all, I am trying to migrate from MSSQL Server 2000 to MySQL 5.0.
While migrating two tables named MaxCount and National Holidays of collegesnaps database , I am facing trouble during 5th step.


The message log is as below.



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 have gone wrong and how to correct it .

there is also the MySQL migration tool kit 9available as part of the MySQL GUI tools
.... just a thought