Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Migration to Dynamics ...
Microsoft Dynamics CRM (Archived)

Migration to Dynamics CRM 2016 on-premises

(0) ShareShare
ReportReport
Posted on by AKREM

Hi team,

We have a web site using an oracle database called for example "MyOrganization". We need to migrate to Dynamics CRM 2016 on-premises. In this case, we will do a manually transformation of this oracle database to an Sql Server database called "MyOrganization_MSCRM" that respects the structure of CRM database (to be imported after in a deployment).

What we think, is to transform each table "tableX" in oracle to a table "tableXBase" in Sql Server that represents the entity called "tableX" and replacing the Foreign keys to other table with a GUID.

I shared with you my concerns and I would ask you whether you could suggest me any idea or any clue to achieve this.

Thanks a lot..

Akrem

  

*This post is locked for comments

  • AKREM Profile Picture
    AKREM on at
    RE: Migration to Dynamics CRM 2016 on-premises

    Hi guys,

    Could you give me any suggestion with more details? If there is anyone who has experience in this.

    Thanks,

    Akrem

  • Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Migration to Dynamics CRM 2016 on-premises

    Sorry for the previous suggestion. It wont automatically do it. You have to write the code to update it

  • Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Migration to Dynamics CRM 2016 on-premises

    No you have it wont automatically replace you have to do it

  • AKREM Profile Picture
    AKREM on at
    RE: Migration to Dynamics CRM 2016 on-premises

    Thanks very much Jason.
    Just a last questions, Does KingswaySoft adapter automatically replace the Foreign Keys with GUIDs of other entities?
    And for SSIS, it will be something like this:

    KingswaySoft.png

    Thanks again!

    Akrem

  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,558 on at
    RE: Migration to Dynamics CRM 2016 on-premises

    Use something like SSIS with a CRM adapter like KingswaySoft to insert the data into the CRM database. Use SSIS to read from your source database, do any transformations, and then insert into CRM. The adapter uses the CRM web services to handle data, attempting to insert directly to the CRM database is unsupported and will almost certainly end up not working due to all the internal processes acting on the data during any of the normal CRUD type operations. No doubt staging your source data into tables that are close to the CRM schema will make the move to CRM easier. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans