locked
Moving data from Microsoft Dynamics CRM to SQL Server RRS feed

  • Question

  • Hai All,

    We have a requirement to move the data from MS CRM 2013 to a SQL Server. So could you please let me know what are the different possible ways to migrate the data. I know the ways to do from SQL to CRM but not vice versa.

    Thanks in advance

    Sravani

    Wednesday, November 16, 2016 1:55 PM

All replies

  • Hello,

    Actually CRM DB is SQL db so you can use it directly. If you anyway want to migrate data so in your case you can make SQL 2 SQL migration using SSIS for example.


    Dynamics CRM MVP
    Read My blog
    Subscribe for one of my courses

    Wednesday, November 16, 2016 3:21 PM
    Moderator
  • Hi Sravani,

    I would recommend that you write your own code using MS CRM SDK to migrate required data and automate as needed.

    Here are some other options... 
    1. Export data to excel (using Out Of the Box functionality) and then create SSIS to import it in SQL Server Database (could be time consuming job)
    2. Filtered Queries (Source CRM) > Use SSIS > Import data into SQL Server Database.

    (I haven't tried following tool personally so not sure how helpful it will be.)
    3. Kingswaysoft (Video tutorial - https://www.youtube.com/watch?v=d26ziRxodWc)

    I hope this helps.

    Narayan

    • Proposed as answer by NeeNarayan Thursday, November 17, 2016 11:47 AM
    Wednesday, November 16, 2016 3:48 PM
  • Hello,

    Actually CRM DB is SQL db so you can use it directly. If you anyway want to migrate data so in your case you can make SQL 2 SQL migration using SSIS for example.


    Dynamics CRM MVP
    Read My blog
    Subscribe for one of my courses

    Hi Andrii,

    I do not recommend direct interaction with MS CRM database (Not supported) exception is accessing data using Filtered Views.

    If you need to do like to like replication then we can use Subscription/Publication option available from MS SQL Server.

    Let's say we ignore Microsoft recommendation then also reading data directly from MS CRM Database tables could be tricky that's why Microsoft have created Filtered Views.

    This forum also discusses the same - https://social.microsoft.com/Forums/en-US/5221d3a0-a58b-42f8-8bc8-ea0d897c2d3e/accessing-the-crm-database-directly?forum=crmdevelopment

    I hope this helps.

    Narayan

    Thursday, November 17, 2016 11:47 AM