Answered by:
CRM Import

Question
-
We suffered a system crash and lost our CRM box. I was able to retrieve the CRM database from SQL.
We now have a new box w/ fresh install of CRM 2010, etc.
What is the best way to import this data? I tried to use SQL export/import wizard but it fails due to table relations.
I can access the data manually thru SQL and can dump to xml, csv, etc.
Thanks!
Friday, February 15, 2013 8:26 PM
Answers
-
Hi Steven,
Have a read of the implementation guide http://www.microsoft.com/en-us/download/details.aspx?id=3621
In short, restore your SQL db in SQL management studio, open up the CRM Deployment Manager from your newly installed CRM2011 box and select 'import organisation'. You should be able to select your restored SQL db after defining the SQL instance to use, then just follow the wizard and map your users.
Rob
Microsoft Certified Technology Specialist (CRM) GAP Consulting Ltd Microsoft Community Contributor Award 2011
- Proposed as answer by Rob BoyersEditor Friday, February 15, 2013 8:32 PM
- Marked as answer by JLattimerMVP, Moderator Sunday, March 3, 2013 5:12 AM
Friday, February 15, 2013 8:32 PMAnswerer
All replies
-
Hi Steven,
Have a read of the implementation guide http://www.microsoft.com/en-us/download/details.aspx?id=3621
In short, restore your SQL db in SQL management studio, open up the CRM Deployment Manager from your newly installed CRM2011 box and select 'import organisation'. You should be able to select your restored SQL db after defining the SQL instance to use, then just follow the wizard and map your users.
Rob
Microsoft Certified Technology Specialist (CRM) GAP Consulting Ltd Microsoft Community Contributor Award 2011
- Proposed as answer by Rob BoyersEditor Friday, February 15, 2013 8:32 PM
- Marked as answer by JLattimerMVP, Moderator Sunday, March 3, 2013 5:12 AM
Friday, February 15, 2013 8:32 PMAnswerer -
Thanks Rob, I will try your advice on Monday and report back.
Not positive but I think we tried the traditional import (through crm) and it didnt work. Again, will report back on Monday with more info.
Saturday, February 16, 2013 10:56 AM -
Hi,
You should import the organization DB from deployment manager. Make sure the user runing this operation should be deployement administrator. You can follow the below url:
http://technet.microsoft.com/en-us/library/hh127042.aspx
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Yogesh Vijay Mulay
Monday, February 18, 2013 3:13 AM -
Thanks for the reply, I will try both of your suggestions tomorrow.. I had intended to do it on Monday but I had a couple of my apps go live and have had no extra time.
Thanks again and I will let you know how it works..
Thursday, February 21, 2013 10:56 PM