Wednesday, August 20, 2008 4:57 PM
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.
Sunday, August 24, 2008 1:54 PMI'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 PMModerator
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.
Wednesday, August 27, 2008 1:23 PM
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.
- Marked As Answer by Donna EdwardsMVP, Owner Monday, June 01, 2009 4:34 PM