Hi Folks,
I have upgraded SugarCRM commuinity edition to SuiteCRM, but I have upgraded the same for my TEST environment only. Now I am planning to cloning the database from LIVE (which is in SugarCRM) to TEST (SuiteCRM).
Do I need to perform any additional task or take any precautions before doing it? Following the configuration of my systems:
LIVE Settings:
SugarCRM Community edition (Version 6.5.16)
Server version: 5.5.34-0
ubuntu0.12.04.1
Web server
Apache/2.2.22 (Ubuntu)
MySQL client version: 5.5.34
phpMyAdmin Version information: 3.4.10.1
TEST Settings:
SuiteCRM (Version 7.9.17)
Server version: 5.5.59-0
ubuntu0.14.04.1 - (Ubuntu)
Apache/2.4.7 (Ubuntu)
Database client version: libmysql - 5.5.59
phpMyAdmin Version information: 4.0.10
Thanks!
Small detail: you didn’t mention your PHP version, make sure it’s within the compatibility Matrix requirements. But I guess it is.
Now, the important part:
DON’T try to migrate a SugarCRM database to a SuiteCRM database, unless you are willing to do it table by table, checking field by field.
You should always use the Upgrade packs to upgrade, and only migrate DB between two instances on the same SuiteCRM version. This is because the upgrade scripts change database structure and many other things behind the scenes.
Basically, an upgrade and a migration are two different things, never try to do both in a single move.
So you need to plan for running an upgrade on your server with the full production data (even if it is a clone running in a test system), and then put that server live.
1 Like