Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Move SQL server tables...
Dynamics 365 general forum

Move SQL server tables to dynamics 365 online

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have the task of moving Sage 100 data CRM to Dynamics 365 CRM. So far I have been able to move data from Sage 100 CRM to SQL server. Now I want to move all those tables to our Dynamics 365 online. There are around 1200 tables in SQL server which I have to move to dynamics 365 (The number of destination entities in Dyanmics CRM are lesser than the number of SQL tables). I tried using SSIS for this so that I iterate through all tables and their rows but I find it's going wrong since I have to specify a destination entity table for our organization's dynamics. I just want to simulate SQL server's export wizard here. Can someone help me on this?

I know that it sounds absurd to move all these tables from sql server to dynamics 365 as my organization is only going to use few of them but this is a client requirement. How can we create new tables on dynamics crm online server if they aren't present?

Categories:
Customization / Solutions / SDK and API
Integration with Other Products
  • Suggested answer
    Jason Lewiss Profile Picture
    Jason Lewiss on at
    RE: Move SQL server tables to dynamics 365 online

    It can be done via Skyvia without coding.

  • Verified answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at
    RE: Move SQL server tables to dynamics 365 online

    You have to create 1200 entities in dynamics CRM or you have to merge tables in one entity.

    Once you complete entity creation then go for SSIS.

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Move SQL server tables to dynamics 365 online

    Hi,

    You have to create yourself, how do you make sure the field data type and format in Sage are same as in Dynamics 365.

    Besides that, since you have 1200 tables to be imported, have you check the maximum entities you can have in Dynamics 365? You can refer below blog on how to check the number.

    nishantrana.me/.../resources-in-use-300-custom-entities-limit-in-dynamics-365-online

  • Verified answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Move SQL server tables to dynamics 365 online

    Hi,

    It is not possible to move tables. The data in CRM online is stored under entities which in itself is a sql table. So if you are looking for moving sql table as is then its not possible. You need to create entities and then move the data using some process from your sql table to dynamics 365 entities.

    Hope this helps.

  • Suggested answer
    Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: Move SQL server tables to dynamics 365 online

    You're going to have to create an entity and columns for each and every table you want to migrate over to Dynamics.  And frankly you don't want to do that (which it sounds like you know already).  

    As an alternative, there are Virtual Entities in Dynamics, where you could surface up that SQL data in Dynamics without actually loading the tables themselves into the Dynamics database.  That might be a nice middle ground if they really do need to "see" those tables in Dynamics, but won't be working on them directly.  docs.microsoft.com/.../get-started-ve

    But I would definitely push back hard and get a really clear business case on why those tables need to be in Dynamics the same way.  Worst case scenario, when it doesn't do what they want it to do, you have something to cover yourself.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans