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

Posted on 2011-10-14
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

    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

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now