Solved

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

Posted on 2009-07-09
10
219 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
[X]
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
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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