Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: Problem during migration from MS SQL to MySQL

    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 .

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there is also the MySQL migration tool kit 9available as part of the MySQL GUI tools
    .... just a thought
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •