Moving from SQL SERVER to MYSQL

Discussion forum for Enterprise Edition.
Post Reply
noamway
Posts: 66
Joined: Sat Aug 12, 2006 5:11 am

Moving from SQL SERVER to MYSQL

Post by noamway »

Hello,

Today we're using SQL SERVER for all postoffice configuration and we like to move to MYSQL.
This is what we did and want to know if this is the right way to do that:
1. We migrate the details of the DB from SQL SERVER to MYSQL (using migration tool).
2. Now we like to use the "Provider Migration Utility" to add a the connection settings of the MYSQL.

This is the right way to do that? or the schemes of the DB will be different and what I did it's wrong?
Do I need to do more things before I'm doing the change?

Thanks

Admin
Site Admin
Posts: 1127
Joined: Mon Jun 10, 2002 6:31 pm
Location: Melbourne, Victoria, Australia

Re: Moving from SQL SERVER to MYSQL

Post by Admin »

Hi,

To change to using MySQL instead you just need to use the provider migration tool. So you would configure the MySQL settings using that tool and use the "Populate" option to move the settings from one database to the other. It does not matter about the schema since the tool is reading each setting and then adding it. So you can move to from the Tab Delimited/SQL Server/MySQL options.

noamway
Posts: 66
Joined: Sat Aug 12, 2006 5:11 am

Re: Moving from SQL SERVER to MYSQL

Post by noamway »

It's a very big DB and I want it to be fast. So can I use it without the need to "Populate" the data using the GUI?
I mean I will duplicate the data before making the change with the GUI

Post Reply