Migrate database from MSSQL to MySQL

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
leo_246
Posts: 13
Joined: Sat Aug 06, 2005 9:25 pm

Migrate database from MSSQL to MySQL

Post by leo_246 » Mon Jan 16, 2006 1:40 pm

Is this possible without to much work ?

matteo
Posts: 572
Joined: Sun Nov 20, 2005 6:53 pm
Location: Italy

DTS

Post by matteo » Mon Jan 16, 2006 1:45 pm

You could try to export the data in your MSSQL DB in a .sql standard file and then try to import it within MySQL (phpMyAdmin will help you), this above AFTER you've configured the MySQL DB with a fresh (==empty) PMF installation.
If there will be issues on creating a standard .sql data export e.g. you could try to use an ad hoc DTS script (the mapping is simple: 1<->1) with access to MySQL via ODBC.
phpMyFAQ QA / Developer
Amazon.co.uk Wishlist

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

migration tools

Post by jazcyk » Wed Jan 18, 2006 1:38 am

http://www.databasejournal.com/features ... 97_3550146

The tool that MySQL released is not as easy to use at all.

matteo
Posts: 572
Joined: Sun Nov 20, 2005 6:53 pm
Location: Italy

Post by matteo » Wed Jan 18, 2006 1:38 pm

matteo wrote:You could try to export...
For clarity sake, I would ask you, leo_246: do you have already try with the export functionality of PMF (please, in the admin menu click on Backup)?
My previous post was supposing that this functionality doesn't work within your environment.
phpMyFAQ QA / Developer
Amazon.co.uk Wishlist

leo_246
Posts: 13
Joined: Sat Aug 06, 2005 9:25 pm

Post by leo_246 » Wed Jan 18, 2006 8:53 pm

I have tested backup functionality in admin menu and it is working.
I got some errors on the import but it is not important for me.

Code: Select all

Query: "INSERT INTO faqchanges (id,beitrag,lang,usr,datum,what) VALUES (1,6,'nb',0,1137254504,'')" failed (Reason: 515)

jazcyk
Posts: 385
Joined: Wed Sep 07, 2005 1:32 pm

datatypes

Post by jazcyk » Wed Jan 18, 2006 9:11 pm

The problem is that you will have to re-map the datatypes when changing database systems. Some dataypes - even a simple thing as varchars for instance - on SQL server and MySQL are not the same!

If you export you will have to edit the .sql-file.

If you use a Migration Tool this tool will use either ODBC (SQLyog) or JDBC (MySQL Migration Tool). The 'mapping' done by either of these ODBC/JDBC drivers are not perfect. You will need to adjust it. It is most easily done with SQLyog.

Post Reply