locked
crm 4.0 to crm 2011 database import RRS feed

  • Question

  • hi

    i want to install crm2011 and i want to use my previous crm 4.0 database where all my data is backed up.can i do this and if yes how do i get about doing this

    thanks 

    Wednesday, August 24, 2011 10:04 AM

All replies

  • Hi,

    Follow the steps:

    1. Install CRM 2011 as mentioned in the following Url: http://social.technet.microsoft.com/wiki/contents/articles/how-to-install-microsoft-dynamics-crm-2011.aspx

    2. Restore CRM4.0  Organization database into CRM 2011 SQL Server

    3. Run CRM Deployment Manager and Import Organization and choose CRM 4.0 database , you may also refer: http://crmbusiness.wordpress.com/2011/03/01/crm-2011-importing-a-crm-4-organisation-into-crm-2011/


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    • Proposed as answer by Jehanzeb.Javeed Wednesday, August 24, 2011 10:48 AM
    Wednesday, August 24, 2011 10:47 AM
  • hi jehanzed

    thanks for the reply. i just have a little more concerns.how many organisations can you have if you have a crm 2011 workgroup deployment.Also what are the necessary requirements in order to import a crm 4.0 database into crm 2011.

    Thanks 


    System integrator
    Monday, August 29, 2011 1:08 PM
  • Hi,

    Dynamics CRM 2011 Workgroup edition have a limit of 5 CALs (Users) and single organization and refer to the steps below for importing CRM 4.0 database into CRM 2011:

    In the CRM 4.0 SQL Server
     
    1.Back up the 4.0 organization database (the one with the _MSCRM after it), to a .bak file on disk.
     
    In the CRM 2011 SQL Server
     
    1. Restore the .bak file to it
     
    In the CRM 2011 Deployment Manager
     
    1.Run the Import Organization wizard


    2.Import the SQL database you restored in the previous step

    3. During User Mapping choose Keep Exsisting User Mapping (becuase your domain is same)

    You may also refer: http://technet.microsoft.com/en-us/library/gg197663.aspx

    http://crmbusiness.wordpress.com/2011/03/01/crm-2011-importing-a-crm-4-organisation-into-crm-2011/


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, August 29, 2011 2:24 PM
  • i tried importing the crm 4.0 database into the sql server  but i keep getting this error

     Restore failed for Server 'MS-DYNAMICS'.  (Microsoft.SqlServer.SmoExtended)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

     

    ------------------------------

    ADDITIONAL INFORMATION:

     

    System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&LinkId=20476


    System integrator
    Monday, August 29, 2011 3:09 PM
  • hi jehanzeb

      i followed all the steps you outlined here and it seemed to work.but when the import finished the imported organizations status showed failed.what could be the problem


    System integrator
    Thursday, September 15, 2011 11:23 AM