Business Central – The Cloud Data Migration Tool

Business Central – The Cloud Data Migration Tool

The Cloud Data Migration Tool

Customers running their workloads on-premises can migrate to Business Central online by running the cloud migration tool; the same tool can also be used to set up a connection to the intelligent cloud but still remain on-premises.

“Data Migration Tool” page link https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migration-tool

HOW SYSTEM WORKS

ASSISTED SETUP – PAGES & STEPS TO MIGRATE ON CLOUD!

The assisted setup guide consists of pages that take you through the process of connecting your solution to the Business Central cloud tenant.

ASSISTED SETUP

Product selection

On this page, specify the on-premises solution that you want to replicate data from. All supported sources will appear in the list. If you don’t see your product, navigate to the Manage Extensions page, and then verify that the intelligent cloud extension for your on-premises solution is installed.

SQL Connection

If the product you selected requires a SQL connection, this page will be presented. Other source applications may require different information to connect to them. This page will display the connection information based on the product that you specified in the previous page. This is defined from the installed extensions for the product you have selected.

Self-Hosted Integration Runtime (SHIR)

This is the service will allow access to the Azure replication services to your on-premises SQL Database during the migration process. Follow the instructions on this page to install the Self-Hosted Integration Service (SHIR) to a local machine.

Companies Selection

You will be provided with a list of companies from your on-premises solution, or source. Select the companies you would like to migrate data for. If the company does not exist in your Business Central tenant, it will be automatically created for you.

Enable & Scheduling Migration

The final page in the wizard allows you to enable the migration process and create a schedule for when the data migration should occur. These settings are also available within your Business Central tenant on the Cloud Migration Management page. You have the option to schedule migrations daily or weekly. We recommend that you schedule your data migration for off-peak business hours.

https://chrisdsilvablog.files.wordpress.com/2020/08/image-11.png?w=578

Let’s start from “ASSISTED SETUP”


Open “SET UP CLOUD MIGRATION”

Cloud Data Migration Setup

Choose Business Central Release (16 or 15) – (Current or Previous)

Define:

  • SQL Server (or SQL Azure) database connection string
  • An Integration Runtime Name

You can define a new Integration Runtime Name (if you don’t already have one)

SQL Server- SQL Azure Connection String sample

Server=SERVER\INSTANCE;Database=DATABASENAME;UserID=xx ;Password=xxxxx;

Pay attention to:

  • TCP Network Active (activate all network interfaces if you have connection problems), check TCP Ports
  • Check Firewall and rules (or disable firewall)
  • Check for SQL Named Instance, use “\\” (double slash) separator “to avoid escape error on Json”

cid:image012.png@01D68055.ED97C390

cid:image013.png@01D68055.ED97C390

…and Test always connection!

…Now assign an Active Integration Runtime Name

Integration Runtime Name Example

A name like this “msweua6461tf89X8X7”

System requirements – check for these:

To connect to the cloud through Business Central, the on-premises solution must use SQL Server 2016 or a later version, and the database must have compatibility level 130 or higher. Sql Server data compression available for Business Central v16 demo database.

EXAMPLE SCENARIO

  • SQL SERVER 2016SP1 (with data compression available)
  • DEMO DATABASE BC (16-0)

Check Database Property (upgrade to 130)

Download Azure Data Factory Integration Runtime

https://www.microsoft.com/en-us/download/details.aspx?id=39717

Configure Integration Runtime

SQL NAMED ISTANCE CONNECTION TEST

YOU ARE READY TO LAUCH CLOUD DATA MIGRATION

SELECT COMPANIES TO MIGRATE (OR MIGRATE ALL COMPANIES)

CLOUD MIGRATION MANAGEMENT

RUN MIGRATION NOW

OR SCHEDULE DATA REPLICATION

RESULTS

ALL MICROSOFT LINKS ABOUT THIS TOPIC

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

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

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

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

FAQ

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/faq-intelligent-cloud

6 thoughts on “Business Central – The Cloud Data Migration Tool

    • Author gravatarAuthor gravatar

      I think there should be a space in between User and ID in the connection string. EG
      Server=SERVER\INSTANCE;Database=DATABASENAME;User ID=xx ;Password=xxxxx;
      Not
      Server=SERVER\INSTANCE;Database=DATABASENAME;UserID=xx ;Password=xxxxx;
      I also found testing the connection in Integration Runtime Configuration Manager needed the double \\ between the hostname and instance, but not when you are actually writing the connection string.

    • Author gravatarAuthor gravatar

      Hi Roberto,

      Thnaks for your post as always. I have one siomple question. Once de integretion runtime is ready, and made one migration, is there any way to “restart2 it, and setup a new configuration? I don’t inde the way….

      Thank you again!

    • Author gravatarAuthor gravatar

      Hello Roberto

      Great post.

      Where can I find the Integration Runtime Name? I have followed yor explanation about that but I am get an error in the BC Data Migration Setup when I inform the Integration Runtime Name.

      If I left this field blank (as shown in the officel guide ) I get the error “Failed to create your integration runtime.”. If I inform a random name (as in your explanation) I get a different error: “There is insufficient memory to execute this function. This can be caused by recursive function calls. Contact your system administrator.”.

      Where can I find this name? I don’t have any integration runtime created before. I have installed the integration runtime shelf-hosted.

      Thanks in advance.

      • Author gravatarAuthor gravatar

        Hi Iñaki,

        I have the same problem as you. I worked with this feature one ocassion in the past without any problem, but now I have the same problem.

        Could you fix it?.

        Thanks in advance.

    • Author gravatarAuthor gravatar

      Hello Álvaro
      I didn’t do anything special bur after two or three days without doing anything it worked. The only thing I did was reboot the server where the onpremise database was located.
      May be in theese days the SaaS version was upgraded (and solved the problem) but I left the “Integration Runtime Name” field blanked and the process went on without any problem. The onpremise version was 17.4 and (I think) Saas version was 17.5.
      Sorry not to help more.

      • Author gravatarAuthor gravatar

        Hi Iñaki,

        Thanks for your reply. I rebooted the server where the onpremise database was located without success.

        It’s strange because with 17.4 (I think) Saas version the process worked. I thought it could be because of the update to version 17.5 of Saas.

        I fill the “Integration Runtime Name” because I already have an instance installed but if I leave the field empty I also get an error.

        I will keep triying.

        Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: