Heavy Metal Guitar   

Results 1 to 3 of 3

Thread: MSSQL To MySQL

  1. #1

    Join Date: Oct 2008
    Location: Faribault, MN
    ME: Charvel MetalCaster
    Rig: Line6/Carvin

    iTrader: 0


    Anyone have a tool to make this easy? I found one, but its $100 to buy or the free 30 day trial is 2 tables at a time. Painful!

  2. #2

    Join Date: Feb 2011
    Location: Stockholm, Sweden
    ME: Cort M520
    MA: Ibanez V320
    Rig: Pod X3 Live

    iTrader: 0

    I don't know of any tools, but is your db complicated (structure, triggers, foreign keys, stored procedures)?

    If not maybe you can just export as sql scripts and iron out the differences manually?

  3. #3

    Join Date: Dec 2008
    Location: Pennsyl-tucky
    ME: 87 Ibanez RG550
    MA: Wasburn D12 6
    Rig: ADA MP1 / Spider II

    iTrader: 0

    i don't know enough about mssql

    if you can convert your mssql to a CSV file you can import that.

    Note that mysql has different data types (no boolean..) You would need to use the SET data type for a boolean and put '0','1' in the length/values box. There are probably other differences but none come immediately to mind...

    I dont use stored procedures so I have no idea how/if you could pull those over.

    you would want to set up your tables and data types in phpmyadmin first (easier than using terminal....) name your fields the same as in the first line of your CSV.

    After your table is set up

    Click on the import tab

    browse to your file and select it

    click on CSV using load data

    under options for Fields terminated by enter a comma (,)

    click go

    For Mac Sequel pro is really nice (if you dont have phpmyadmin access - it basically works the same)

Similar Threads

  1. MSDE / MySQL Server 2005 Express - auth question
    By Chris in forum Computers, Electronics, Gaming & IT
    Replies: 2
    Last Post: 11-17-2009, 01:14 PM
  2. Just upgraded to Snow Leopard: Some notes for MX Revolution and MySQL users.
    By zepp in forum Computers, Electronics, Gaming & IT
    Replies: 5
    Last Post: 09-16-2009, 11:32 AM
  3. Oracle buys Sun, MySQL concerns
    By Chris in forum Computers, Electronics, Gaming & IT
    Replies: 8
    Last Post: 04-24-2009, 03:46 PM
  4. Fuck MySQL
    By noodles in forum Computers, Electronics, Gaming & IT
    Replies: 17
    Last Post: 02-27-2009, 02:39 AM

Tags for this Thread

Fractal Audio Systems  Shred Training  Angel Vivaldi
Bowes Guitarworks  Decibel Guitars  NumbSkull Audio Production

VigLink badge