DB change: MySQL -> SQL

[valueprice]

Hello everyone,

we like to move our SugarCRM database from MySQL 5.1 to MS SQL, preferrably 2008. Is there a walkthrough available for this scenario?

Kind regards,
Robert

[crmsiva]

In Phpmyadmin there is an option available namely "SQL compatibility mode" in the Export page/tab. You can set the option as MSSQL. After that you can import the dump into MS SQL Server.

[DigiCRM]

There is a tool in the MS SQL package which convert a MySQL database into a MS SQL
or
You can Export your data in CSV or SQL format then import in MS SQL

[valueprice]

HI,

thanx for the quick help. Now I must tell SugarCRM to use the MS SQL instead of the existing MySQL. I guess I need to run the setup wizard again to do this?

Kind regards,
Robert

[SugarDev.net]

No you have to look at config.php and make your changes there. You could ask around for the right settings or just install a temporary new installation next to it and grab that config file. Do not run setup again on your existing installation.