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?
Join Date: Oct 2008
Location: Faribault, MN
ME: Charvel MetalCaster
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!
Join Date: Feb 2011
Location: Stockholm, Sweden
ME: Cort M520
MA: Ibanez V320
Rig: Pod X3 Live
Join Date: Dec 2008
ME: 87 Ibanez RG550
MA: Wasburn D12 6
Rig: ADA MP1 / Spider II
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 (,)
For Mac Sequel pro is really nice (if you dont have phpmyadmin access - it basically works the same)