?
Solved

CRM 2011 Data transfer

Posted on 2014-03-04
22
Medium Priority
?
741 Views
Last Modified: 2014-03-19
Dear All,

Good Day,

In our ORG we are running with Domain (2003 Server), CRM 2011 Server, now i created new Domain (new domain there no release with old domain) with win 2008 R2 Server and did the fresh installation of CRM 2011 Server, could any one help me how can i move my CRM data from my old CRM server to new CRM server.

Waiting for your reply

BR
Kumar
0
Comment
Question by:Ram Kumar Chellam
[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
  • 14
  • 8
22 Comments
 
LVL 30

Accepted Solution

by:
Feridun Kadir earned 2000 total points
ID: 39902738
High level steps are:

1) In older domain, do a backup of the CRM organization database in SQL Server
2) In the new SQL Server, restore the backup
3) In the new CRM Server, run the CRM Deployment Manager and run the Import Organization wizard selecting the newly restored database

If you need more help with the above steps please post again.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39903282
Hi Feridum,

I tried these but i'm getting the attached error message.

Waiting for your support

BR
Kumar
CRM2011.jpg
CRM2011a.jpg
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39903311
The errors mean that the user account you are logged in as whilst performing the import must be mapped to a user in the CRM database that has the System Administrator role.

Do you know which user in the database had the System Administrator role?  There could be more than one, it doesn't matter which one you choose.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:Ram Kumar Chellam
ID: 39903417
but here domains are different, i took CRM SQL backup from Old Domain and restore the DB in new CRM on New Domain, once i started  running the CRM Deployment Manager and run the Import Organization its asking me the user which have Admin Role and choose the user (CRM Administrator) which is having the Admin Rights, but still its giving me the same error

BR

Kumar
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39903723
I understand that the domains are different.  The list of users that the wizard shows you are the users defined in the CRM database.

Each CRM user has a record in the CRM database and each one user is mapped to an Active Directory account (in the old domain). The wizard relinks each user record to an Active Directory account in the new domain.

You must link the user you are logged in as to one of the users in the list that has the System Administrator role (it doesn't matter of the user names are different).

Did your Windows account have a CRM user record in the old domain with the System Administrator role?  If not and you are having trouble you could go back to the old CRM and make sure that you have a user record with System Administrator and then do the backup and restore process again.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39905512
ok let me try again
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39905649
As per you commend i went back to my old CRM 2011(Which is running one my Old Domain) and given full Admin Right to my user (kumar) and taken the backup, restore it in new CRM 2011 (which is running in new domain) and try to run the CRM Deployment Manager and run the Import Organization  and choose the kumar user, but still its given me the same error, please check the attached image

BR

Kumar
crm2011.jpg
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39905774
Did you give the user the role named System Administrator? It must have that exact role. You can the user other roles as well, but it must have System Administrator ".
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39906076
yes that user having full rights
crm.jpg
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39906771
Hmm, this is puzzling. What is the Access mode set to for your CRM record in the old database?

Is it Full, Administrative or Read-Only?  It should be Full.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39908459
It was read-only, just changed to Administrative.

Let me restore the new back up and update you the status.

BR
Kumar
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39908520
Result is same after given Administrative access, plz let me know there is anyother way

BR

Kumar
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39908856
You need to change the access mode to full not Administrative.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39909222
there is no option for FULL, please check the attached image

Thx
CRM.jpg
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39909236
Oops, my mistake, apologies. The Access Mode should be set to Read-Write and the License Type set to Full.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39909395
Access Mode - Read-Write and License Type - Full but still giving me same error
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39909438
I try to managed that one and went to the next step and its give me 2 error message please check the attached file.

for the old error i used the below link:

http://www.ryanonrails.com/2011/07/09/import-crm-2011-organization-error-you-must-map-your-active-directory-user-account/

Waiting for your reply

BR
Kumar
CRM-Error.jpg
0
 
LVL 30

Expert Comment

by:Feridun Kadir
ID: 39909458
These errors probably mean that you have not applied an Update Rollup to the new installation. Check which Update Rollup is applied to the old installation (in Add/Remove Programs, view installed updates) and ensure that the same or later update rollup is applied on the new server.

Glad you got the other problem sorted.
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39910451
thx for your support let me check my servers and update you soon

BR

Kumar
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39915466
i checked as per you request there is no update, but in the old domain CRM V 5.0.9690.3236

In New Domain CRM V 5.0.9688.583, could you please tell me how can i do the update

Waiting for your reply

BR

Kumar
0
 

Author Comment

by:Ram Kumar Chellam
ID: 39915486
just Find the Roll-up 12 for that CRM V, started installing, let me try again and update you shortly

BR
Kumar
0
 

Author Closing Comment

by:Ram Kumar Chellam
ID: 39939130
Thx
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

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.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

764 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