Converting MS SQL Tables to MY SQL

Discussion in 'MySQL' started by RedDem0n, Feb 6, 2009.

  1. #1
    I have a few tables in my MYSQL database that I'd like to send over to a MY SQL database and develop a few queries applications based on it. The tables have no stored procedures or triggers - Can anyone recommend a good tool or method to do the conversion process?
     
    RedDem0n, Feb 6, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    If they'rent a lot, manually doing it wouldn't be a way?
    if you dont want it manually,
    I have a software bought for 49$
    I can merge your tables for 10$
     
    crivion, Feb 6, 2009 IP
  3. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Look at the first link in my signature
     
    graformix, Feb 6, 2009 IP
  4. QiSoftware

    QiSoftware Well-Known Member

    Messages:
    805
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    158
    #4
    MS Access comes with some pretty advanced export features-- check the help area. You should be able to export the schema and content and upload to a mySQL database with phpmyadmin pretty easily.

    Q...
     
    QiSoftware, Feb 6, 2009 IP
  5. supportresort

    supportresort Member

    Messages:
    28
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    48
    #5
    supportresort, Feb 8, 2009 IP
  6. RedDem0n

    RedDem0n Peon

    Messages:
    67
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    thx all give some of these tries and report as to which one worked
     
    RedDem0n, Feb 9, 2009 IP
  7. kellywriter

    kellywriter Banned

    Messages:
    81
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #7
    There are some softwares which converts automatically sqlserver databast to mysql database. Other way is generate sql script and paste it in mysql using phpmyadmin
     
    kellywriter, Feb 9, 2009 IP