Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2009-07-09
10
217 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

860 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