locked
CRM 2011 Restore Custom Entity RRS feed

  • Question

  • Folks:

    One of our CRM Custom Entity got deleted a few days back and we just noticed it when one of our reports failed. I have the database backup and in the backups I can see the 2 tables and FilteredView for that tables. Also, the entity is missing from the CRM view and so I'm sure it got deleted. How can I restore only the missing custom entity without overwriting the full data?

    Thanks !


    • Edited by sqldba20 Monday, December 3, 2012 8:33 PM
    Monday, December 3, 2012 8:17 PM

Answers

  • On Dev:

    Settings -> Customizations -> Solutions

    New Solution 

    Assign values to the required fields and Save

    Select Entities -> Add Existing

    Choose the deleted entity and Save

    Export Solution

    No need to Publish (assuming it has been already) & Next to System Settings

    Choose Unmanaged

    Export

    Save the resulting file 

    On Prod:

    Settings -> Customizations -> Solutions

    Import

    Browse to the file

    Next to begin the import


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    • Marked as answer by sqldba20 Tuesday, December 4, 2012 3:59 PM
    Tuesday, December 4, 2012 2:46 AM
    Moderator

All replies

  • There really isn't any procedure for a situation like this unfortunately besides restoring the entire database.  

    An option might be to restore the backup someplace else and extract the data and then get in into Excel and do a data import or use the CRM SDK to create an application to re-create the data. 


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Monday, December 3, 2012 9:51 PM
    Moderator
  • In our DEV environment I have the same customization. Is it possible to copy that using Export / Import? If so, could you walk me through the steps. For now I'm not worried about the data in this entity because we can insert into manually later. First is getting the customization in place.

    Thanks !

    Tuesday, December 4, 2012 12:55 AM
  • On Dev:

    Settings -> Customizations -> Solutions

    New Solution 

    Assign values to the required fields and Save

    Select Entities -> Add Existing

    Choose the deleted entity and Save

    Export Solution

    No need to Publish (assuming it has been already) & Next to System Settings

    Choose Unmanaged

    Export

    Save the resulting file 

    On Prod:

    Settings -> Customizations -> Solutions

    Import

    Browse to the file

    Next to begin the import


    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    • Marked as answer by sqldba20 Tuesday, December 4, 2012 3:59 PM
    Tuesday, December 4, 2012 2:46 AM
    Moderator