Skip to main content

Migrating Data from Business Central On-Premise to Business Central Online


After the Business Central On-Premise is ready with the Customization and Data, it's time to migrate the Business Central On-Premise Environment to Business Central Online(Cloud).
The end goal in mind is to migrate to Business Central Online(Cloud)


- Microsoft Dynamics Business Central(On-Prem & Online)
- Microsoft Azure Data Factory Runtime
- Basic understanding of SQL Server and Azure Data Factory

Books & References:


1. Setup SQL Server Authentication:
Setup the SQL Server Authentication to SQL Server Authentication as follows.
Enable Windows and SQL Server Authentication Mode
Right Click on SQL Server Instance > Properties > Security > Server Authentication as SQL Server and Windows Authentication mode
SQL Server Authentication Set to Windows and SQL Server

Goto Security > Logins > <Username> > Right click Properties > Status. Set the Login to Enabled.

 Restart the SQL Server by right-clicking on SQL Server Instance > Restart

2. Setup SQL DB Compatibility Setup:
Go to Database properties > Options > Compatibility Level > Check the compatibility level.
The compatibility level should be 130 and above.

If the compatibility level is less than 130 then you can set it to 130 by calling the following SQL Query.

3. Setup Business Central Cloud Data Migration:
- Login into Business Central Online Environment where you want to migrate all the data.
- Go to Assisted Setup > Migrate Business Data > Set up a cloud Migration > 

Assisted Setup

This opens Cloud Migration Setup Wizard.
Cloud Migration Setup Wizard - Accept Agreement and hit Next

Cloud Migration Setup - Product Selection (Select Business Central earlier versions)

Select Product Types based upon your Business Central On-Premise version

Fill in the SQL Connection String, keep Integration Runtime Name as <BLANK>
Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;
Select SQL Connection String

Download and Setup Self-hosted Integration Runtime

I downloaded the latest Microsoft Integration Runtime and run the Installer.
Download Microsoft Integration Runtime

Install and Setup Microsoft Integration Runtime Setup

Microsoft Integration Runtime - Installer Wizard

Microsoft Integration Runtime - Accept EULA

Microsoft Integration Runtime - Select Destination Folder
Microsoft Integration Runtime - Install

Microsoft Integration Runtime - Finish

Microsoft Integration Runtime - Setup Authentication key and Register

Microsoft Integration Runtime - Integration Runtime (Self - Hosted) Nodes

Microsoft Integration Runtime - Configuration Manager

The Microsoft Integration Runtime Configuration Manager is a place to get the status of your Integration Runtime. You can also run diagnostics from the same.

Microsoft Integration Runtime - Runtime Status

Microsoft Integration Runtime - Diagnostics Tool

Note: The SQL Connection String in Microsoft Integration Runtime is setup in JSON hence an additional '\'  escape character is needed in Integration Runtime. However, Business Central accepts SQL Connection String.

After the Microsoft Integration is Setup, you can go to Business Central and add your SQL Server Connection String and Integration Runtime Environment and hit next.
Depending upon the size of the DB the session goes on 'Working on it...'. Hence do not close this session else you will have to redo the setup once again.

For me the DB size was 40GB, the session was inprogress for 3.5hours.

Cloud Migration Setup - Processing.

After this, the next step is to select companies to synchronize.

Select the companies that you want to migrate and finish the Cloud Migration Setup.

Cloud Migration Setup is completed.

Now you can open the Cloud Migration Management Page. You will see that a queue is created and scheduled.
Cloud Migration Management

Hence, after the upgrade is successfully completed, you will see the following details.
Cloud Migration Management - Data Migration Completed

For any details regarding the procedure refer here.


Cloud Data Migration is one of the most time-consuming tasks in terms of Data Replication and Data Upgrade.
It took 5 hours to migrate around 25 tables for a Database size of 40GB.
Do read through the details provided on the procedure.

Hope this helps :)


Popular posts from this blog

Something went wrong. An Error occurred - Error Resolution

Introduction: With the installation of NAV 2018 or BC On-premise, I have observed that when creating New Server Instance and New WebServer Instance, you will get the error 'Something went wrong. An Error occurred '. I referred to the community questions below but didn't find my resolution. Hence, I decided to write this blog. Pre-requisites: Microsoft Dynamics Business Central - On-Premise / NAV 2018 Understanding of Business Central Authentication  Books & References: Demonstration: 1. Creation of NAVServerInstance: In order to create NAVServerInstance, you can either add the Server Instance through Business Central Administration or Powershell command. Add Instance - Business Central Administration Add Insta

Universal Code Error and Resolution

Introduction: On Friday, May 12th, 2023, the Business Central On-Premise Production Environments started throwing universal code errors as follows. This occurred to every customer on a lower version of BC 19,20 and 21 irrespective of their localization, customization, and license. Pre-requisites:  Understanding of Technical Upgrade in Business Central On-Prem References: BC20 On prem. Universal Code requirement error after installing customer's license. - Dynamics 365 Business Central Forum Community Forum (40) Yammer : Dynamics 365 Business Central Development : View Conversation Root Cause: The certificate that signs Microsoft Base Application was expired. Errors started occurring if you Uninstalled, Installed Extensions, Restart Server Instances or for some even out of random started popping out. We first thought could be a license issue as we had fixed that before but this did not solve the issue. Resolution: Microsoft identified the issue and posted the following update The mi

How to update your Business Central to Latest CU

Introduction:  There are times when Microsoft releases the latest major version upgrade for Business Central Upgrade and you face many issues with it. As soon as the bugs are reported to Microsoft, they start to fix them and ask you to upgrade to a certain Cumulative Update. In this blog, I will be sharing my experience with Business Central v21 CU0 upgrade to Business Central v21 CU2. Pre-requisites:  Business Central DVD for Latest CU Basic Understanding of Business Central CU Updates Books & References:  List of Update Packages How to Update CU version Demonstration:  1. Check the current state of BC: As part of knowing the current state of your Business Central environment, I'm assuming that your Business Central Environment will have some data in the standard Base App also there will be customization with extended tables and newly created tables. Customization - TableExtension on Customer Table  Customization - Custom Table created Make a note of the data that is present i