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.