[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to continuously update data to Microsoft Dynamics CRM from a external MS SQL Server

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
Can someone provide me some guidance on this matter?  Where I can some specific detail to achieve this? Thanks.
Question by:tommym121
1 Comment
LVL 27

Accepted Solution

Chinmay Patel earned 2000 total points
ID: 36970200
Hi tommy121,

There are multiple ways to achieve this :
1. You can use SQL Server Integration Services[SSIS] and come up with a SSIS package that will take care of your data maybe on a short interval of time.
2. You could write a custom .Net service that can run in background and update data on external server.
3. If you want to achieve true real time updates, I suggest you develop a CRM 2011 plugin[a .Net assembly which you bind with trigger kind of mechanism in CRM i.e. whenever your record is created/updated in CRM immidiately it will call your .net assembly] to update external database.

It depends a lot on your exact scenario but these are scenarios you could start with.


Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

834 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