How to combine different Suite CRM instances in One

đź’¬ General Discussion
1

Hi,

I have 10 different SuiteCRM instances and want to combine them in one instance. Are there any easy method to do it? Or any suggestion you have?

Regards,

2

I don’t think it exists. One way will be create a version just for admin purposes and create custom modules and logic to manage the other instances. Big task but interesting concept.

thanks,

BrozTechnologies

3

That would be a very cool and awesome feature though. :smiley:

If you could have a “Multi SuiteCRM” instance version where you could host unlimited amounts of CRM system instances within one install.

That would be extremely useful for sales and marketing agencies for example like mine where you could create a new instance for every new customer without the need to create a new installation for each customer. That would have many benefits for sure.

Pretty much the same principles just like WordPress Multisite where you can create unlimited amounts of blogs/sites within one install…

For now we’re just create new free instances for customers at hub-spot which works fine too. But it would be even better if you could host everything in-house for the sake of guaranteeing customer data integrity etc.

Heck, even though free is nice… If SuiteCRM made a required paid version of that; I would happily pay for that feature to have it on-premise.

Kind regards
PowerQuest

4

Let’s keep this close to topic please!

Hey @dtosun,

Guess you could try exporting the data from each instance and importing into a master crm. Customisation and custom modules would need to be replicated within that master crm for the data import to go smoothly.

Depending on complexity of customisation you could be looking at a lot of work, on top of that you would have to consider the use of the 10 seporate instances. If they all do the same job for the same company your probably fine but if it’s different jobs for different company’s you’ll have to remeber to implement proper security (Access control, password management, roles and groups etc)

A further to that, if you have a shed load of records across the crms you could be looking at days importing them even if you used direct SQL to SQL transfer.

Could be a mammoth of a job :confused:

Let me know if you consider it and how it goes :+1:

5

Hi @Mac-Rae,

Thank you for your response. I can prefer export from instance and then import to master crm. But what about the relational data?

6

My point, you would much better be exporting the database SQL and combining then.

7

Do you know; if i export from instance and then import to master crm, Is relational data also imported to master crm?
How can i combine the database SQL? I should know database schema very well.

8

Importing is not the most reliable method as you will lose maybe type of relational data. Connect to the mysql database terminal and take a backup .sql of the database. Then you should be able to import again via terminal all the .sql backups to a single database.

9

I will try🙄 I hope i can do it without error. I afraid of duplication error.

10

After importing them all you can run the duplicate finder which should help fix that issue :+1: