CRM 4.0 data migration from sql 2005 to 2008 RRS feed

  • Question

  • Hi,
     I have CRM 4.0 installed on Win 2003 and sql 2005.Now we are plannig to upgrade sql from 2005 to 2008.What my question is can I restore the databases from Sql 2005 to 2008 and make the registry changes to point to new sql 2008 sever.
    Thursday, January 13, 2011 10:26 AM

All replies

  • Yes you can restore the databases to SQL2008. If you are not changing the CRM server, you can update the SQL Server by editing the organisation properties in the CRM Deployment Manager.

    I don't think there is a need to make any registry changes.


    Thursday, January 13, 2011 11:21 AM
  • Hi,

    Thanks for your reply...Let me give your more details.I just made the Proof of concept for the above question and was successfull in doing as you mentioned above.Now I want to upgrade my CRM server from windows 2003 to windows 2008 and I want to use the same sql 2008 server.will there be any known issues,If yes could you please provide me some details and resolutions as well.


    Thursday, January 13, 2011 1:01 PM
  • Are you planning an in-place upgrade of Windows 2003 or a re-install?

    For an in-place upgrade I'm not sure whether you will run into any issues with the CRM installation. For a re-install, you will need to install CRM from new. During installation create a new organization (this will be deleted later). Once CRM is installed, go to the Deployment Manager and import your existing organisation by pointing the wizard to the SQL Server and selecting the appropriate database.  Make this organisation the default, disable the new organisation created during installation and then delete it.

    Also, check out this link regarding CRM on Windows 2008 http://support.microsoft.com/kb/950100

    • Proposed as answer by Jim Glass Jr Thursday, January 20, 2011 6:12 PM
    Thursday, January 13, 2011 2:01 PM