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

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?
ruud00000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rakeshAgarwalCommented:
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
ruud00000Author Commented:
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
rakeshAgarwalCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

ruud00000Author Commented:
OK so I start with installing CRM WITHOUT existing database?
0
rakeshAgarwalCommented:
yes - reason  you AD guids are all changed  thats why.


regards
rakesh
0
ruud00000Author Commented:
And first remove the crm databases that I imported in SQL before ?
0
rakeshAgarwalCommented:
just remove MSCRMCONFIG database

put name organisation name as yourorgnametemp


then it will be easier for you
0
ruud00000Author Commented:
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
rakeshAgarwalCommented:
import organization will take care

this will appear  in menu
0
ruud00000Author Commented:
Done, Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.