Migrating SQL/Server to mySQL

Hello -

 

I have an old website that I am replacing with D6.1.6  My old site database is in SQL/Server. I was wondering if there are any scripts I can use to migrate my data from SQL/Server to mySQL / D6.1.6. Please note, the only data I am concerned with are: UserID, Password, Email@, and gender - the process should be simple.

I'd appreciate any input/help you can provide. Thank you.

-AJ 

Quote · 23 Dec 2009

what I do is use the SQL tool and write  a short query to get them out.

then use a good editor to do find and replace  say: `pass` to `Password`  where `Password` is dolphins table

you can even do a reverse to see exactly how it should looke coming out of dolphin....make a profile and then use pypmyadmiun to do thw SQL and SELECT all fields FROM `Profiles` then find the "export" at the bottom and then you will get the exact lines needed to insert.

I have video tutorials to help you mrpowless.com
Quote · 24 Dec 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.