locked
CRM Import RRS feed

  • 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

    Friday, February 15, 2013 8:32 PM
    Answerer

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

    Friday, February 15, 2013 8:32 PM
    Answerer
  • 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