Changing from Mysql to MSSQL

Discussion in 'MySQL' started by Dirty-Rockstar, Jul 10, 2009.

0
  1. #1
    is this difficult? or is it as easy as uploading the DB and changing the source from mysql_xxx_xxx to mssql_xxx_xxx. does it support the same type of queries as mysql?

    thanks
     
    Dirty-Rockstar, Jul 10, 2009 IP
  2. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    It's impossible to do that just changing the source . Its not difficult but requires the types corection and brining them in compliance. Easy to solve it with a tool with data mapping functionality
     
    graformix, Jul 10, 2009 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    There are transfer tools out there. Most likely you can't simply dump a sql file, but it isn't extremely difficult. Best bet is to look for a mysql to mssql migration tool.
     
    jestep, Jul 10, 2009 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    Also, in my experience views, triggers, and stored procedures have to be migrated manually.
     
    jestep, Jul 10, 2009 IP
  5. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #5
    Right, difference between SQL dialects doesn't allow to migrate queries directly from mysql to MSSQL
     
    graformix, Jul 10, 2009 IP
  6. rayqsl

    rayqsl Active Member

    Messages:
    91
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    53
    #6
    You can export your data structure commands to a file and run the SQL in MSSQL and you can export your data from MySQL into CSV files and then import them again into MSSQL.

    If you go down this route, you'll need to handle each table separately but you could become unstuck with foreign keys if they are identity columns.

    And as said previously, triggers, indexes, constraints and anything that is out of the ordinary may not work and they need to be checked very closely. And you MUST check the datatypes and decide how they will work (or not work) in MSSQL.

    Good luck.
     
    rayqsl, Jul 21, 2009 IP