Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM Import RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

    Friday, February 15, 2013 8:32 PM
    Answerer

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

    Friday, February 15, 2013 8:32 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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