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


    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

    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.


    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


    Jehanzeb Javeed

    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





    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