MSCRM Adapter

melissa

I have the challenge of keeping 4 Microsoft MSCRM databases in sync, development, qa, stage & production.

Problem is you cannot write to the MSCRM databases via SQL without using the MSCRM adapter.

Is there a way to use Red Gate SQL and Data Compare to compare and update using the mscrm adapter?

Ben Pinchen

I'm not very familiar with MSCRM. Do you need to do everything through the adapter so that the right changes are made to other parts of the CRM system? If everything has to go through the adapter then I can't see a way of utilizing SQL compare/SQL Data Compare. We'd have to add the functionality to the applications to support this.