Move from SQL Server to MySQL

[bwalker]

Hello!

I'm looking for a method to move from our SQL Server instance to a MySQL instance.

The source is:

OS: Windows XP
Sugar Suite: 5.0.0f
Webserver: Apache 2.0.59
PHP: 5.2.2
Database: MSSQL 7.0

The destination is:

OS: Mac OS X 10.4 Server
Sugar Suite: 5.0.0f
Webserver: Apache 2.0.59
PHP: 4.4.3
Database: MySQL 5.0.19

I've tried and failed with Jitterbit. Wasn't able to log in.

I look forward to any suggestions.

Thanks in advance!

[ptemplin7]

Search around. There are ways to do this I think the Wiki had some thoughts. The web also talks about it.

The biggest change is that ALL date-Time fields need to be converted to a correct format. See attached for myswl to MSSQL you may be able reverse engineer it.

Good Luck,
Paris