Answered by:
CRM 2011 Restore Custom Entity

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 AMModerator
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- Proposed as answer by Scott Durow (MVP)MVP, Editor Monday, December 3, 2012 10:21 PM
Monday, December 3, 2012 9:51 PMModerator -
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 AMModerator