Data Import from SQL Server RRS feed

  • Question

  • Hello Everyone

    I am new to CRM 2011.

    I want to import data from SQL Server database to CRM 2011.

    Could anyone guide me in the right direction and provide links on what is involved and some simple sample code as well.

    Thanks in advance.

    Thursday, March 8, 2012 4:53 PM


  • Yes, it is possible.  There are several ways to go about this task.

    Here are a couple:

    1. You could use a third party migration/integration tool that complies with the CRM SDK like Scribe (www.scribesoft.com)

    2. You could write your own .NET application or build an SSIS package that uses web service tasks to perform the update.  SSIS packages can use SQL Server Agent to schedule jobs and you can use many different methods to do this with a .NET application.  If writing your own you will need info from the SDK:


    Software Specialist Crm

    • Marked as answer by WPF_Dev Friday, March 9, 2012 9:44 PM
    Friday, March 9, 2012 7:54 AM

All replies