comparing object collections between environments? RRS feed

  • Question

  • Hello, I'm trying to figure out if there's a way to compare the object collection between CRM environments. I'm assuming that all objects in a CRM environment are stored somewhere in the primary CRM database so I'm guessing that what I'm trying to do could be accomplished with SQL queries. I'm guessing that these objects are stored in several different tables and it may be time-consuming and error-prone to try to write a custom query to accomplish what I'm trying to do. Here are a few of the different object types I'd like to compare between environments:

    * entity
    * email template
    * javascript web resource

    Those are just a few of the object types I can think of offhand.  I'd like this report to include all object types. I'm wondering if someone else here has already written a query like this that he could share or if this type of comparison ability might already be provided by a third party tool for CRM?
    Tuesday, March 18, 2014 9:53 PM