Solved

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

Posted on 2009-07-09
10
221 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

695 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