Sugarcrm CE 6.2.0 to SuiteCRM migration

omejiasq · 3 November 2015 15:03

Exists one complete process for migrate sugarcrm CE 6.2.0 to SuiteCRM ? Where i can to see one database ER diagram?

MarkusP · 4 November 2015 11:49

I had to migrate from SugarCRM CE 6.5.2x to SuiteCRM 7.3 and also was looking for a possibility do the migration within one step, but failed.
Likely even though SuiteCRM has the same basis like SugarCRM there are too many small differences to do it within one step.

Finally with these steps the migration was a success.
1 ) Full backup of the old installation
2 ) Upgrade SugarCRM 6.5.2x to SuiteCRM 7.1.x using the proper update package of SuiteCRM and the update wizard
3 ) Upgrade SuiteCRM 7.1.x to 7.3.x using the proper update package of SuiteCRM.
4 ) Download of the installation package for SuiteCRM from Bitnami (7.3)
5 ) Install SuiteCRM on the new machine using the Bitnami installer - the installation scripts deactivates SELinux before the installation and reactivates it afterwards.
6 ) Export the data via phpmyadmin from the old installation
7 ) Import the data to the new installation via phpmyadmin into a new database and relocate the SuiteCRM installation to that new DB
8 ) Rebuild layouts

omejiasq · 4 November 2015 15:40

Thanks friend. I have some questions:

I have 6.2.0 SugarCRM CE. I need first upgrade my old version to 6.5.2 as SugarCRM upgrade packages?
Really i need Bitnami for to installa SuiteCRM? i have one clean and new installation in Centos without Bitnami. Can i to do it as this installation of SuiteCRM?
Export the data via phpmyadmin is export all data without sctructure?
After i import only the data exported from my step 4 to my structure installed in step 2? I need clean the data of all tables of my SuiteCRM installation?
Rebuild layout is by rebuil option? i need restart anymore as httpd?

Regards,

Edgar M

omejiasq · 4 November 2015 16:19

Besides of before questions, if i have advanced developments for example REST integrations, logic hooks, javascript validations, this is migrated or i need to buil newlly this adaptations?

freitasjcarlos · 6 November 2015 21:11

Dear All,
I have the same version of Sugar (6.2.3) and would love now if I have to migrate first to 6.5.20 an them to SuiteCRM.

MarkusP · 9 November 2015 09:52

omejiasq:

I have 6.2.0 SugarCRM CE. I need first upgrade my old version to 6.5.2 as SugarCRM upgrade packages?
Likely yes, as the SuiteCRM package is named “Migrate from SugarCRM 6.5.x to SuiteCRM 7.1.8”.
It seems that the upgrade requires 6.5.x to work.

Really i need Bitnami for to installa SuiteCRM? i have one clean and new installation in Centos without Bitnami.
Can i to do it as this installation of SuiteCRM?
I guess you also can work with a manual installation of SuiteCRM. I had some strange permission issues, because of SELinux,
so the manual installation didn"t worked for me.

Export the data via phpmyadmin is export all data without sctructure?
The export via phpmyadmin exports the data and(!) the structure of the DB.

After i import only the data exported from my step 4 to my structure installed in step 2? I need clean the data of all tables of my SuiteCRM installation?
That didn’t worked for me, but I’m not that experienced. I created a new database and imported the export from the old installation.
So the migrated structure and the all data was there.

Rebuild layout is by rebuil option? i need restart anymore as httpd?
If you have some custom fields, you need to add them to the layouts and check if all (custom) lists etc are available.

Please note that I’m not that experienced, there might be better ways to achieve the goals than I described it.