Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Unanswered: Inport MS SQL Server "sql script" into MySQL

    Hello all, I have an MS SQL server dump/sql script that i want to use in a new MySQL database. Obviously the syntax isn't the same but is there a way to convert that entire script to iso/mysql syntax? I have over 50 tables and doing this manually is not very inviting....

    Help anyone?????

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you have a script generated from SQL Server? that's actually not all that easy to do

    conversion to mysql syntax in a text editor using search/replace is straightforward but might be tedious

    i'm not aware of any tools that work on the DDL itself (although that doesn't mean there aren't any)

    what did you find by googling "convert ms sql server to mysql"?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why not try one of the migration tools.. such as the MySQL Migration toolkit? available from the MySQL site
    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
  •