Skip to main content

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

Introduction:

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)


Pre-requisites:

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

Books & References:

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data

Demonstration:

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.
ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 130

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.

Conclusion:

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 :)





Labels:

Comments

Post a Comment

Let me know your comments below. I'll try my best to answer your comment

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: https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/261301/nav-2018-web-client-an-error-has-occurred https://community.dynamics.com/business/f/dynamics-365-business-central-forum/421987/error-something-went-wrong-an-error-has-occurred-azure-ad-tenant 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...
Post a Comment
Read more

How to resolve 'Edit in Excel' issues

  Introduction: As you know that D365 BC offers Edit in Excel functionality. But manipulating or customizing such a  standard functionality is difficult as there is not much control available. Hence, solving issues is also a difficult task. I will be resolving the issue for this specific issue, however, the debugging steps are similar. Pre- requisites : ODATA V4 Connectivity tool for Webservices Microsoft Dynamics 365 Business Central Books & References: https://community.dynamics.com/business/f/dynamics-365-business-central-forum/448226/issue-with-excel-add-in/ Demonstration: The way Edit in Excel works is that for a given page a Webservice is created adding PageID and Page Name. Hence, there are some Webservice connectivity checks in place to validate. 1. Edit in Excel Custom Action on the page: If you are adding Edit in Excel Action on the page, please ensure that you are providing appropriate PageName and Filter criteria as Webservice is using these parameters Refer Ed...
Post a Comment
Read more

Installing LS Central - POS on local machine

Introduction: In this blog, I'm attempting to capture the LS Central - POS installation process on Local Machine. This blog has nothing to do LS Central - Server Setup for POS. LS Retail / LS Central - On Premise POS Pre- requisites : LS Central Installed on Server SSL Setup on LS Server (https://www.olisterr.tech/2020/03/how-to-setup-navuserpassword-with-ssl.html) LS - POS Installer Business Central - On Premise Installer Demonstration: Once your LS Retail / LS Central POS is setup on the main server. Just prior to Go-Live, you will actually have to install this POS on multiple systems and connect these POS to the main server with LS Retail / LS Central. 0.Preparation: Prior to actually installing Business Central On-Premise Windows Client, you need to make sure that you're able to ping the target with the correct Port number. For this I made use of PS-Ping tool.  PSPing - IP Address: Port If you're unable to PS-Ping the correct IP with Port number, simply check the Advan...
Post a Comment
Read more