Wednesday 3 July 2019

Migrate Data from Business Central On Premises to Business Central On Cloud with Extensions

Hello Everyone,

In this article, we would discuss about migrating data from Business Central On Premises to Business Central On Cloud using Intelligent Cloud with Extensions.

Reference Link: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/about-intelligent-edge

Important Notes:

1) Before setting up the connection to the intelligent cloud, ensure that at least one user in the system that has SUPER permissions. This is the only user that will be allowed to make changes in the Business Central tenant.

2) The amount of data that can be replicated for any tenant is limited to 150 GB. If your database is larger than 150 GB, try reducing the number of companies you are replicating data for. (Current Limitation)


3) SQL Business Central On Premises Database Compatibility Level: 130

Step by Step Instructions:

1 - Business Central On Cloud - Assisted Setup





2 – Setup Intelligent Cloud




3 – Intelligent Cloud Setup



4 – Replicate Data From Business Central


5 – SQL Database Connection


Server={SQL Server Name};Database={Database Name};User Id={SQL Server Authenticated UserName};Password={SQL Server Authenticated Password};

Server=SERVER01\SQLSERVER2016;Database=Base DB BC Spring 2019 Build 29530 Cloud;User Id=sa;Password=xxxx;



6 – Self Hosted Integration Run-time

Copy the Authentication Key in Notepad as it would be used in later steps. Download and install Self Hosted Integration Run-time from link in the screenshot. Complete Steps 7, 8, 9 and 10 before clicking Next in Step 6. After clicking Next in Step 6 Go-to Step 11.



7 – Install Microsoft Integration Run-time



8 – Authentication Key - Register

Copy and Paste the Authentication key that was saved in Step 6.



9 – Integration Run-time Registered Successfully



10 – Integration Run-time Configuration Manager



11 – Replicate Companies from Business Central On Premises



12 – Schedule Replication



13 – Intelligent Cloud Setup Completed



14 – Setup Intelligent Cloud Completed



15 – Replication Initialization Completed



16 – Company CRONUS Canada, Inc. – Created Successfully – On Cloud



17 – Intelligent Cloud Management – Run Replication Now

This process would replicate data from Business Central On Premises to Business Central On Cloud.



18 – Replication Triggered Successfully



19 – Replication Results



20 – Replication Statistics



21 – Replication Status Information

Data Replicated Successfully.



22 – Extension – Business Central On Premises - Item Table

Now we have created a simple Extension extending Item Table and created a new Custom Table in On Premises Environment. We have also inserted sample data for same in On Premises Environment.



23 – Extension – Business Central On Premises – Custom - Intelligent Cloud Table



24 – Extension – Business Central – On Cloud

We have installed the same Extension created above in Business Central On Cloud Environment.



25 – Run Replication – On Cloud

Now as same Extension is installed in Business Central On Premises and Business Central On Cloud, this process would replicate data for same.



26 – Replication Completed Successfully



27 – Data – Item Table – Business Central On Cloud



28 – Data – Custom Intelligent Cloud Table – Business Central On Cloud



That's it !!!


I hope this would help you a lot. Please also let me know your views.

Your valuable comments and feedback are appreciated.

25 comments:

  1. Hi I've been talking about this in
    Dynamics Saturday 365 Madrid :
    https://youtu.be/Tiu7o_ut8UQ
    https://www.slideshare.net/mobile/DemianRaschkovan/dynamics-saturday-madrid-2019-javier-armesto

    ReplyDelete
  2. Replies
    1. Data is only replicated from the on-premises solution to your Business Central online tenant.

      Delete
  3. very interesting post.this is my first time visit here.i found so mmany interesting stuff in your blog especially its discussion..thanks for the post! Paulus Heule

    ReplyDelete
  4. Hi Suraj,

    How we can upgrade from NAV 2016 to Business Central with Extensions and its Data Migration.

    Please let me know if you have an idea and share if any links for reference.

    Thank you

    ReplyDelete
    Replies
    1. Hello,

      You can upgrade from NAV 2016 to Business Central 14x version and then to Business Central Wave 2.

      Kindly find below links for reference.

      https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-data
      https://docs.microsoft.com/de-de/dynamics365/business-central/dev-itpro/upgrade/upgrade-v14-v15-compatibility
      https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-overview-v15

      Delete
    2. Hi Suraj,

      For the mentioned first link is for using Extension or normal up-gradation as we do upgrade from NAV 2016 to NAV 2018 version.

      As i know we make Extension in Business central spring version using by al but i don't have an idea about how to migrate data from NAV to Business central with Extension.

      Thank you
      Suresh Ravuri

      Delete
    3. Hello,

      For upgrading to NAV 2018, kindly refer below link
      https://docs.microsoft.com/en-us/dynamics-nav/upgrading-to-microsoft-dynamics-nav

      For your second question about migrating data from NAV to Business Central,
      Migrate Data from NAV 2016 to Business Central On-Premises version and then follow steps mentioned in this blog.

      Delete
  5. https://msdaxtech.blogspot.com/2015/03/data-migration-framework.html?showComment=1606303272019#c739672894331979252

    ReplyDelete
  6. Really great article.
    After upgrading the data, i have many tables in warning : The table does not exist in the local instance.

    Some of the are coming from extensions that are not in by BC 14 on prem but. Others are tables that that are custmized in c/side.

    I used the TXTtoAL to generate the extension. I deployed all extension in the Online versin.

    If I check the data all my custom field are empty.

    Any idea where it come from ?

    Thank you for your help.

    BR
    ISA

    ReplyDelete
    Replies
    1. The BC 14 is from a migration of NAV 2018.
      i followed the migration process https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrading-the-data
      until Task 14 as my NAV 2018 did not have V2 extension.(migrated from 2013R2)

      Delete
    2. Hello Isa Tahiri,
      If you are Upgrading from NAV 2013 R2, then Upgrade path is NAV 2013 R2 ==> NAV 2018 ==> D365BC 14.x ==> BC SaaS

      You need to ensure that your Custom field data is maintained when you convert to Extensions.

      Reference Link: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/upgrade-to-microsoft-base-app-v17

      Delete
    3. Hello Suraj Patel,

      Thank you for your quick answer. When you say BC SaaS you mean SaaS or Online right ?

      BR
      ISA

      Delete
    4. Or to get into the Cloud version do I have to follow this path :
      NAV 2013 R2 ==> NAV 2018 ==> D365BC 14.x ==> BC SaaS ==> BC Online ?

      Delete
    5. BC SaaS is BC Online
      and if you are upgrading from NAV 2013 R2, yes you need to follow path
      NAV 2013 R2 ==> NAV 2018 ==> D365BC 14.x ==> BC SaaS ==> BC Online

      Delete
    6. Not sure if it is clear to me.
      The last step D365BC 14.X --> BC Cloud (hosted by MS) I followed this step :
      https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-business-central-on-premises

      The url you mentionned explains how to migrate BC14.x OnPrem to the last BC OnPrem.
      As I would like to migrate to the BC Cloud from BC 14.X OnPrem the Extension convertion is still mandatory ?

      Thanks again for your time
      BR
      ISA

      Delete
  7. The Data Migration Assistantis a helpful tool that guides you through the process of moving data from one Mac to another. It provides step-by-step instructions that make the process as easy as possible.

    ReplyDelete
  8. website The Coastal Vacations Business Opportunity continues to supply Membership Benefits and Services that are unparalleled in the business today. They provide a superb holiday package which has un-equalled value to the consumer, as well as tremendous financial rewards for the selling team.

    ReplyDelete
  9. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information? It is extremely helpful for me.

    ReplyDelete
  10. This article is an appealing wealth of informative data that is interesting and well-written. I commend your hard work on this and thank you for this information. You’ve got what it takes to get attention. local moving company denver co

    ReplyDelete
  11. Nice and informative post. Most of the IT sectors prefers cloud solutions for their organization. Cloud migration services helps for the companies to move the next level. Keep sharing more content like this.

    ReplyDelete