Steven
asked on
Migrate CRM 3 data to CRM 4 install
I have a CRM 3 environment running behind a SQL 2000 database located on a Windows Server 2003 platform. We have rolled out a CRM 4 deployment running SQL 2005 on a Windows Server 2008 platform. We have minimal data within our CRM 3 environment but of course we would like to migrate our CRM 3 data to our new CRM 4 environment. Does anyone have any good ideas to make this happen?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
It would be quicker for you now to just export the data from CRM 3.0 then import into CRM 4.0.
The import wizard shoule be able to do this for you no problems.
http://www.ibisinccrm.com/?p=101
Or you could use the data migration manager from here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6766880a-da8f-4336-a278-9a5367eb79ca&DisplayLang=en
Cheers,
MH
It would be quicker for you now to just export the data from CRM 3.0 then import into CRM 4.0.
The import wizard shoule be able to do this for you no problems.
http://www.ibisinccrm.com/?p=101
Or you could use the data migration manager from here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6766880a-da8f-4336-a278-9a5367eb79ca&DisplayLang=en
Cheers,
MH
ASKER
I downloaded the Data Migration Manager tool this morning and attempted to run, however when first running this tool it asks for the CRM location and a text box below has "http://" filled in. I have tried both our public and internal addresses and it would error out saying the server must be down? I will get the exact error message tomorrow but the server is definitely not down. So I need to export all of the data to a .csv then reimport with the import wizard....it sounds too easy.
It is pretty easy.
Export the different entities to different CSV files then run the imports using the import wizard.
MH
Export the different entities to different CSV files then run the imports using the import wizard.
MH
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well to begin, I attempted using the Biffster's idea...via the link he provided about importing/exporting .csv but I haven't had much luck with this.
I am still unable to connect when I open the Data Migration Manager. When I open this utility on my local machine, it asks for an Intranet Address. I have listed both my external and internal urls and both times I get an error: "The configuration wizard cannot connect to the Microsoft CRM server. This might indicate the server is down."
Well my server is not down....and both internally and externally we can access our CRM4 deployment. Any further suggestions apprectiated. Thanks.
I am still unable to connect when I open the Data Migration Manager. When I open this utility on my local machine, it asks for an Intranet Address. I have listed both my external and internal urls and both times I get an error: "The configuration wizard cannot connect to the Microsoft CRM server. This might indicate the server is down."
Well my server is not down....and both internally and externally we can access our CRM4 deployment. Any further suggestions apprectiated. Thanks.
I had the same issue last week, I found out that I had to download the langueas as the CRM installation.
The use I tried to log in with had English but the server was Danish, so I had to download the Danish version instead.
See if it help
/A
The use I tried to log in with had English but the server was Danish, so I had to download the Danish version instead.
See if it help
/A
ASKER
I know I'm English on both ends but are you saying download additonal languages to my laptop they may exist within the CRM4 deployment? With this Migration Utility, am I supposed to punch in the CRM3 or CRM4 server url?
No if it's english it should not be a problem.
The url is to CRM.
/A
The url is to CRM.
/A
ASKER
I understand it's to CRM.....I have a CRM3 deployment on one server, and CRM4 deployment on a different server. What url is it asking for? The CRM3 or CRM4 url?
ups sorry ;-) 4
ASKER
Here is our plan of action per Microsoft:
1. Upgrade SQL 2000 to SQL 2005.
2. Upgrade CRM 3.0 to CRM 4.0.
3. Move CRM 4.0 SQL database to Server 2008 machine which has SQL 2005.
4. Move CRM 4.0 to the Server 2008 by installing CRM 4.0 on Server 2008 by pointing to existing databases
1. Upgrade SQL 2000 to SQL 2005.
2. Upgrade CRM 3.0 to CRM 4.0.
3. Move CRM 4.0 SQL database to Server 2008 machine which has SQL 2005.
4. Move CRM 4.0 to the Server 2008 by installing CRM 4.0 on Server 2008 by pointing to existing databases
And that's the right way to do it, but if you have a heavy customized CRM 3.0 and having ISV solutions, then maby you sould if possible create a test enviroment where you test the upgrade.
Normally I setup a virtual enviroment where I install a basic CRM 3.0 and then runs my upgrade from there.
Did you get acces to the DMM
Normally I setup a virtual enviroment where I install a basic CRM 3.0 and then runs my upgrade from there.
Did you get acces to the DMM
ASKER
I understand the proper way going about this was what you first described, upgrading to SQL2005 then redeploying. I might not mind that method all that much if I get a collective response that indicates it's the best route to take. Any further suggestions are appreciated. Thanks.