Regarding single entity restore RRS feed

  • Question

  • Hi,

    In our crm application we are using etl operation on one entity. In any case if that operation fails then we have to rollback the database.

    Earlier we used to restore the whole database to bring to stable version(ie,state before etl operation).

    Now we are in search of different solution. we are trying to restore single entity instead of restoring whole database.

    If anyone having any idea please let me know.






    Tuesday, January 4, 2011 4:58 PM


  • I reckon you have 2 possible approaches:

    1. Use SQL restore to restore individual tables. If the entity you're loading data into is a custom entity, and you've no plugins or workflows running of it, then it may be viable to just restore the <entityname>base and <entityname>extensionbase tables. This should work, but you'd want to do a lot of testing to ensure you don't corrupt the database. I wouldn't recommend this approach if you're loading data into a built-in entity, as other tables could also be affected

    2. Or, rollback by deleting the affected records. If your etl operation updates CRM in a supported way, then the modifiedon and modifiedby attributes should give you sufficient information to determine which records to delete

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, January 4, 2011 6:48 PM