Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [Alex] Migration from MS SQL (Win) to MySQL (Linux)

Quote Reply
Re: [Alex] Migration from MS SQL (Win) to MySQL (Linux) In reply to
One other suggestion that may be a bit easier. Install MySQL on the windows machine, and install MyODBC as well. Setup a DSN for your MySQL database. You can then right click on the MS SQL database in Enterprise Manager, and click export. Select the DSN you just setup and it will copy the entire database at once to mysql.

Once you have it in mysql, you can just do:

mysqldump database > file

Copy that file to the new server and load it in.

mysql database < file

Cheers,

Alex
--
Gossamer Threads Inc.
Subject Author Views Date
Thread Migration from MS SQL (Win) to MySQL (Linux) Brahms 1453 Sep 17, 2002, 2:56 AM
Thread Re: [Brahms] Migration from MS SQL (Win) to MySQL (Linux)
Alex 1388 Sep 18, 2002, 12:27 PM
Post Re: [Alex] Migration from MS SQL (Win) to MySQL (Linux)
Alex 1383 Sep 18, 2002, 12:29 PM