Asked by:
How to automatically update data from prod to test CRM 2013 Online

Question
-
Hi Guys,
I have two CRM 2013 Online, one is production and other one is test.
How can I migrate all data from Prod to Test?
In addition, is it possible to run this on Schedule? Like every night around 21:00 all new changes done to Prod will automatically get synced to test?- Edited by iCRM Monday, December 16, 2013 2:19 PM
Monday, December 16, 2013 2:18 PM
All replies
-
Hello,
I would suggest to use SSIS or Scribe.
Dynamics CRM MVP/ Technical Evangelist at SlickData LLC
My blog- Proposed as answer by JLattimerMVP, Moderator Monday, December 16, 2013 4:19 PM
Monday, December 16, 2013 2:35 PMModerator -
Use the Microsoft Dynamics CRM 2011 Instance adapter to synchronize data between two Microsoft Dynamics CRM 2011 organizations. This adapter is for use with Connector for Microsoft Dynamics only
http://www.microsoft.com/en-ca/download/details.aspx?id=35385
[Prerequisite]
- You should have a dedicate server to run the connector tool
- You should have the same customization between your Live env and Test env.
[Resolution]
- Install Connector for Microsoft Dynamics AX on the server with SQL Server instance.
- Import the Microsoft Dynamics CRM 2011 Instance Adapter into the connector
- Create the Destination configuration and Source configuration like following(Note: URL is the discover url, you can find it at Settings->Customizations->Develop Source):
- Create map to map the entity and fields, you can also change the Check for changes to weekly
Wilson
Tuesday, December 17, 2013 8:41 AM -
Hi Wilson,
Good one, do i need to insatall it for AX or NAV?
Tuesday, December 17, 2013 10:33 AM -
Have you tried it? can it migrate everything? altso acitivites and attachments?
- Edited by iCRM Tuesday, December 17, 2013 12:29 PM
Tuesday, December 17, 2013 12:29 PM