Solved

How Migrate CRM4 on  SQL 2005 32-bit to SQL 2008 64-bit?

Posted on 2009-07-09
10
214 Views
Last Modified: 2012-05-07
I want to Migrate CRM4 from SQL 2005 32-bit to a SQL 2008 64-bit machine.

I made a backup of the old crmdatabe (_MSCRM.mdb, _MSCRMCONFIG.mdb and _ReportServer.mdb) with SQL management studio and exported customizations.

I am about to install CRM now on the new machine. Should I first simply restore the two MSCRM databases in SQL Management studio? Then install using an existing database? Or should I use the CRM4 import option later after installing with a default database? Should I use a redeployment tool (like with upgradng from CRM3) or some other tool or no tool?
0
Comment
Question by:ruud00000
  • 5
  • 5
10 Comments
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 24813031
hope you have taken backup .ldf file aslo  for both the data base

and taken backup of all custom report

install sql
restor database  or attach database
then install crm with existing database

rakesh

0
 

Author Comment

by:ruud00000
ID: 24813085
Thanks. I tried that but then I get an error reporting missing OU (or department). I'm not sure but I think under CRM3 it was the redeployment tool that solved that by creating the necessary ou's before installing CRM with the existing database. Is there a tool for this in CRM4? I don't find it.
0
 
LVL 11

Accepted Solution

by:
rakeshAgarwal earned 500 total points
ID: 24813168
okie here

after installing crm

you need attach org_mscrm database to sql

when you go to deployment manager you have an option for import organization

click on that and select  the above data base org_mscrm

regards
rakesh
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:ruud00000
ID: 24813216
OK so I start with installing CRM WITHOUT existing database?
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 24813224
yes - reason  you AD guids are all changed  thats why.


regards
rakesh
0
 

Author Comment

by:ruud00000
ID: 24813228
And first remove the crm databases that I imported in SQL before ?
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 24813237
just remove MSCRMCONFIG database

put name organisation name as yourorgnametemp


then it will be easier for you
0
 

Author Comment

by:ruud00000
ID: 24813401
Do I have to start setting up CRM after installation (job roles etc) or does the import organisation wizard deal with that?

By the way where do I find the Deployment manager: inthe CRM program or on the CRM setup CD or in the menu that appears automatically on CD startup (there's something called ; data migratiebeheer (Dutch)?
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 24813736
import organization will take care

this will appear  in menu
0
 

Author Comment

by:ruud00000
ID: 24814385
Done, Thanks!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question