Move installation to 2003 server and different database?

Submitted by maxkat on 2013-06-10

Hello,

maybe you can help met out. I have a test installation on a Windows XP which has become production. It is an Apache/MySql/PHP local installation.

Now I would like to move this installation with its data etc to a Windows 2003 server using a seperate SQL 2005 server.

I would like to know what the steps would be to do this.

Thanks in advance!

Max Kattekamp.

If you export data from MySQL as an SQL script (for example using phpMyAdmin), you should be able to import it to SQL Server with some minor modifications.

Regards,
Michał

Hi Michał,

Thanks for your reply. Due to minimal db knowledge I expect the "minor modifications" could be a problem. But if this works all the settings and already entered data is transferred or do I also need to copy the data dir for example?

Greets,

Max.

If you have some attachment files stored in the data directory, you need to copy them over as well.

Regards,
Michał

Okay, i will give it a try!