Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
CRM 4.0 Data Migration -- Transfer data

Answered CRM 4.0 Data Migration -- Transfer data

  • Wednesday, August 20, 2008 4:57 PM
     
     
    Sign In to Vote
    0

     

    Ok. I have imported the data in a SQL Express edition database.  I have a production SQL Server that is running the CRM application.  I want to put the data in that production SQL Server.  What is best process to move the data from the Express database?  Or document or link would be helpful.

     

    Thanks,
    Kent

     

     

All Replies

  • Sunday, August 24, 2008 1:54 PM
     
     
    Sign In to Vote
    0
    I'm sure a full sql db backup will do and just re-import into the new SQL server. It should work.

     

     
  • Wednesday, August 27, 2008 1:15 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Kent, it's not possible to simply import data from a database into the Microsoft CRM database, at least not using any SQL tools. This is because the CRM application has to handle data integrity jobs like creating GUIDs for each row.

     

    You'll need to use either of the data import tools that come with CRM: the Data Import Wizard or the Data Migration Manager. The Wizard is a feature of CRM 4.0, and the Data Migration Manager is a free add-on for CRM 4.0 available to download from the Microsoft website.

     

    Or you can use third-party tools which use the CRM application tier to import records such as Scribe Insight which has an adapter for CRM 3.0 and CRM 4.0.

     

    Hope this helps.

     

    Neil

     

     
  • Wednesday, August 27, 2008 1:23 PM
     
     Answered
    Sign In to Vote
    0

    Thanks.  I had to insall the 32-bit version of SQL Server in order for the DMM to work.  Now I can bypass the express database option.