Creating custom db from Dynamics CRM DB with CRM Security RRS feed

  • Question

  • Hi

    We have a .net application for searching on crm database but  its performance is not good. So we are planning to create a custom database with necessary tables and fields (not all tables and fields from the crm db) and setup the replication to get data populated to custom  database.

    How can I replicate the same crm security model on to the custom database ?



    Monday, January 5, 2015 11:20 AM

All replies

  • First of all, SQL replication is not usually a good idea with a CRM database. The main reason is that, if an attribute is added to any entity that you replicate, it will break replication, and you will have to reset the replicas. Instead, any of the following are more robust: Using SQL mirroring, or custom scripting to backup/restore the database, or SSIS packages to copy data.

    However, even with any of the alternate mechanisms, it is not simple to get the same security model as used in CRM, and would take a lot of work.

    Overall, I think your effort is probably better spent trying to improve the performance of your application, rather than replicating data

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Monday, January 5, 2015 12:04 PM