Set up cloud migration

Path: Administration > Migrate to Business Central online > Migrate from Business Central on-premises > Set up cloud migration · tier official · system administration · narrative reviewed (checked by Opus)

Overview

This section covers the setup work needed before and during a cloud migration from Business Central on-premises to online. Setup establishes the connection and pipelines between the two databases, using an integration runtime and Azure Data Factory preparation and replication pipelines, with compatibility checks and table mapping.

Start with the overview page to understand the components, then follow Run Cloud Migration Setup, which configures the connection and supports delegated administrators and migrating multiple companies. After that, the other pages cover optional adjustments: changing which tables are replicated and whether existing online data is preserved, defining table mappings, and retaining user permissions.

Key points

• Cloud migration setup creates the connection and pipeline between on-premises and online databases using integration runtime and Azure Data Factory pipelines.
• The preparation pipeline and replication pipeline, plus compatibility checks, are part of the setup described in the overview.
• Run Cloud Migration Setup supports delegated administrator approval and selecting multiple companies to migrate.
• Replication settings can be changed to choose which tables are migrated and whether to preserve existing cloud data.
• Table mappings let you rename tables and move fields to table extensions; they can be imported and exported.
• Mapping development uses the ReplicateData property and the OnInsertDefaultTableMappings event.
• Permissions can be retained via the Cloud Migration Management page (enable or disable removing permissions from users) or a custom extension.
• The OnBeforeResetUsersToIntelligentCloudPermissions event and the Intelligent Cloud permission set relate to permission handling.

Learn pages

• Change the way data is replicated to Business Central online: Learn how to use the replication properties to include or exclude specific tables from cloud migration.
• Cloud migration setup overview: Learn what happens when you set up cloud migration from on-premises to Business Central online, including the data pipeline and connection process.
• Define migration table mappings: Learn how to use migration table mapping to rename the table during the cloud migration or to move a subset of fields to a different table or table extension.
• Retain permissions: Learn how to keep the permissions assigned to existing online users so they can continue to work as usual during cloud migration.
• Run Cloud Migration Setup: This article explains how to run the Cloud Migration Setup assisted setup guide to configure the components and connection for migrating data from a Business Central on-premises database to Business Central online environment.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.