Dynamics Community Forum Thread Details

Dynamics CRM 2016 DataBase Merging

HI Friends,

I have a new requirement that i need to merge two CRM 2016 DB into One DB,So what is the best way to achieve it without any failure or broken relationship.?

Whether i should go for Scribe or SSIS, because we have multiple child entities for a single entity.

Please suggest the best way to merge the databases.

Thanks

Shashikant Saxena

Either Scribe or SSIS could be used for this - I'd choose which you are more familiar with. In either case you will need to identify all entities and relationships that you need to merge, and create data flows for each.

You'll find it easier if you preserve the primary key (Guids) for each record when you migrate from one organisation to another. Under normal circumstances there should be unique across each organisation, though if one organisation had originally been copied from the other, this would not necessarily be the case.

You'll also need to check some of the system entities to see if they need to be migrated. For example, transactioncurrency, pricelist, uom. In general, the default records will have the same Guid across organisations, so won't need to be migrated, but you'll need to check

Quick Links