Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Migration from MS SQL (Win) to MySQL (Linux)

Quote Reply
Migration from MS SQL (Win) to MySQL (Linux)
Since we are migrating our server from Windows to Linux we are looking for a method to get all GForum-data to the new server.

How can we get all data moved to the new server which is on linux, apache and mysql? We do not have MySQL on the windows server (and no MySQLMan in the Forum-Admin) and I can't make an sql dump out of MS SQL to MySQL.

Which tables do we need to migrate if we only want to move the users, the categories and their postings in the categories to the new server?

Thanks,

Matt
Classical music on the net: http://www.klassik.com
Quote Reply
Re: [Brahms] Migration from MS SQL (Win) to MySQL (Linux) In reply to
Hi,

We'll look at making this easier in the future by adding a backup/restore routing like Links SQL has. In the meantime, you need to export the tables to a file (Enterprise Manager, click on the table, and then click on Export). That file can then be loaded into MySQL using the LOAD DATA syntax.

You should really move all the tables to ensure you don't miss anything.

Cheers,

Alex
--
Gossamer Threads Inc.
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.