We help IT Professionals succeed at work.

MS Dynamics CRM Data Migration

743 Views
Last Modified: 2013-11-24
We recently switched the server on which our copy of MS Dynamics CRM 4 was installed and need to migrate the old data into the new installation.  The problem is, the old installation wasn't installed correctly and had security / Active Directory issues.  Also, when we installed the new installation, we had to destroy the AD security groups associated with CRM, so we can't log into the original version.  Is there a tool out there that will extract the raw CRM data directly from SQL Server (as CSV, XML, etc.) and then import it into the new instance of SQL Server?
Comment
Watch Question

Do you have a back up of the old system prior to destroying everything useful for the migration?
As a passing observation, when one begins a migration, one needs to analyze the situation and consider things like this . . . and, if one finds oneself in a position of having to do something like destroy things in order to get the new version installed, one should immediately stop and reassess the situation . . . and, IMHO, take back ups of everything if one hasn't done so already.
This is more than shutting the barn door after the horses have run off . . . it is more like asking how to build a barn door so that one can shut it after the barn burned down. ;-)
Principal Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
I will advice you to go microsoft support. As this will help you to get data back.

Data Loss is the biggest thing in the world :( .. I have suffered from it

regards
Rakesh

Author

Commented:
This solution worked in theory, and seems like it would've worked completely if I had tried moving the old database to the new instance of SQL Server.  However, using deployment manager, I was just able to select the old database from the original instance of SQL Server instead. I was unclear in my question, but the original instance and database were up and accessible.

On a side note, importing an organization into deployment manager takes a very long time (20+ minutes) and can appear to hang (particularly when updating users). In my import process, I manually remapped the users in the import wizard, and that seemed to work best. Don't give up if the system looks like it's hanging!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.