Converting Database from MySQL to SQL Server Error - Pls Help.

[plehry]

I'm trying to convert an installation of SugarCRM from MySQL to SQL Server 2008 R2. I have the installation done with a blank database and it works. I converted the database using Microsoft's SQL Server 2008 R2 Migration Toolkit for MySQL. While it gave me some errors, I was able to fix those but when I try to access the site itself with the converted database, I get the following error:

Sugar CRM 6.2.4 Files May Only Be Used With A Sugar CRM 6.2.4 Database

Everything is the same (the PHP version, the database filename, the log filename, IIS). All I do is convert the MySQL database to SQL Server 2008 R2 and try to access the site.

There was another posting here mentioning a change in the config.php file but I haven't changed anything except migrate data from the MySQL database to the SQL Server one.

Any help would be greatly appreciated.

[eggsurplus]

Check out this post on how to deal with this error: http://www.sugarcrm.com/forums/264053-post2.html

[plehry]

Thx Eggsurplus. That query indicated the version was 5.5.1.

I edited the table and changed it to 6.2.4 and it worked. Thx so much.

[eggsurplus]

No problem. Did you ever run the upgrade to 6.2.4? It should have updated that value to 6.2.4 for you. If you didn't run the upgrade you may run into some data integrity issues as there are some data changes at times in the upgrades. It isn't just structural changes. Just a heads up if you come across something odd.

[plehry]

I'm actually doing a conversion from MySQL to SQL Server, so when I do the conversion, it's putting the old version number in there again.

[Angel]

I don't understand how the conversion would be responsible for that, specially if the only difference between the two systems/installs is the database server in use.

What version of Sugar are you running on the source instance?

Same question, but for the SQL Server instance that is blank?