---
id: video/O921cRqXdiw
type: video
title: "What's New: Cloud Migration and Upgrade (2023)"
summary: "Cloud migration and upgrade changes from a 2023 Business Central session: faster replication (bulk copy, table-to-table copy, delta sync, Azure SQL direct linking), a new migration UI, customized-field-to-table-extension mapping, partner telemetry, and plans for the version 14 upgrade path and obsolete object removal."
tier: official
language: en
tags:
  - cloud migration
  - data replication
  - performance optimization
  - azure data factory
  - bulk copy
  - delta sync
  - change tracking
  - azure sql
  - user interface
  - on-premise migration
  - table extensions
  - customized fields
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:15:29.697Z"
  flags: []
generated:
  at: "2026-10-07T23:15:29.766Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 3733742d64ea2c868219cbc1e8a0413a4fd9f4c4c35ece010c20e808f7e2dd0d
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2544s
    title: "Version jump strategy (jump builds every 5 versions): announced"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2544
    quote: we are planning to do these updates every five years so in every five versions We are planning to introduce a jumper build
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=88s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 88
    quote: the number of uh business Central tenants migrating their data from on premise has almost doubled last year comparing to the previous year and
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=108s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 108
    quote: back then we removed the hard limitation on the amount of the UN premis data that can be replicated to the cloud and that
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=382s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 382
    quote: it has become possible to replicate an unlimited number of tables in a single migration run and we remove the limitation on the number
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=444s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 444
    quote: the AL number sequences data type is supported by Cloud migration and the numbering can continue in the BC tenant after migration instead of
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=519s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 519
    quote: our test measurement show 8 to 22% performance benefit for the new process comparing to the old way of inserting the data with all
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=570s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 570
    quote: the whole process of B copy became 60 to 80% faster
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=668s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 668
    quote: if uh Asia SQL is used a source it is possible to link the source and the destination Asia SQL databases directly without the
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=789s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 789
    quote: the more powerful service tier you get the faster and smoother your Cloud migrations will be
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=827s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 827
    quote: it is extremely hard to get an overview which data has been moved and if there has been any problems with the cloud migration
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=887s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 887
    quote: we have decided to support both for the time being because we believe that some of you have done the customizations to the old
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1048s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1048
    quote: now you're able to see which tables have failed the replication and which tables are requiring your attention immediately
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1088s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1088
    quote: to enable you to be more efficient we have added this action which is called unblock the table
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1216s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1216
    quote: tenant media if it was copied successfully it needs to have more records than there are in the on Prem database because we never
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1513s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1513
    quote: we have shipped it with the version 21 actually because we backported the code to make it more efficient
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1566s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1566
    quote: we are going to insert the default mapping by name and we are going to search for all of the fields that we can
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1581s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1581
    quote: you are able to do the these simple migration table mappings and this will copy the custom fields to the Target table if the
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1601s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1601
    quote: you need to rename the fields so you will need to prefix them so they are called the same as in on Prem
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1769s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1769
    quote: we have added a dedicated UI for that and you can access it through this section which is called add table mappings
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=1956s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 1956
    quote: if you do this through code then table mappings are going to be inserted each time when you complete the setup wizard or if
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2036s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2036
    quote: approximately few weeks ago we have added support for the Telemetry and we have added a lot of events to the partner Telemetry
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2265s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2265
    quote: we are stopping the direct upgrate and cloud migration po from version 14
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2319s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2319
    quote: we have 7 years of obsolete removed objects and these objects are taking around 10% of the database
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2360s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2360
    quote: we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26 and we are
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2360s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2360
    quote: we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2441s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2441
    quote: the only thing that you need to do to remove the table and the field from schema is to have a version in which
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2523s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2523
    quote: in order to get to 26 you need to go through 25 so all of these on Prem versions they will need to upgrade
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2544s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2544
    quote: we are planning to do these updates every five years so in every five versions We are planning to introduce a jumper build
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2622s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2622
    quote: currently there are no plans of stopping the on Prem support and if there are any PLs they are going to be announced in
  - kind: video
    url: https://www.youtube.com/watch?v=O921cRqXdiw&t=2713s
    title: "What's New: Cloud Migration and Upgrade (2023)"
    date: "2023-11-21T13:22:01.000Z"
    commit: null
    t: 2713
    quote: if you would like to override this decision you need to do workarounds either to delete the content from the table or to use
links:
  learn: []
  objects:
    - object/table/18
    - object/table/405
    - object/table/9650
    - object/table/77
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: O921cRqXdiw
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=O921cRqXdiw
published_at: "2023-11-21T13:22:01.000Z"
duration_s: 2947
captions: full
audience:
  - partner
  - administrator
  - developer
  - functional consultant
chapters:
  - t: 0
    title: Introduction and Session Overview
  - t: 68
    title: Cloud Migration Usage Growth and Technical Challenges
  - t: 149
    title: Replication Engine Architecture Overview
  - t: 209
    title: "Backend Improvements: Replication Pipelines and Data Copy Optimizations"
  - t: 351
    title: Metadata Handling and Pipeline Improvements
  - t: 482
    title: Table-to-Table Copy and Bulk Copy Optimizations
  - t: 570
    title: Diagnostic Runs and Delta Synchronization Improvements
  - t: 668
    title: Azure SQL Optimization and High-Volume Migration Recommendations
  - t: 809
    title: Cloud Migration Performance and UI Redesign
  - t: 927
    title: New UI Status Overview and Failure Tracking
  - t: 1048
    title: Unblock Table Action and Migration Workflows
  - t: 1128
    title: Company and Table Status Filtering and Tenant Media Tables
  - t: 1277
    title: Data Exploration, Completion Actions, and Table Sanitization
  - t: 1493
    title: Customized Fields to Table Extensions Migration
features:
  - name: Replication Pipeline Metadata Table Handling
    status: unclear
    t: 362
    verified: false
    status_source: video
  - name: Unlimited Tables and Companies in Single Migration Run
    status: unclear
    t: 382
    verified: false
    status_source: video
  - name: Removed On-Premise Database Size Calculation from Replication Runs
    status: unclear
    t: 402
    verified: false
    status_source: video
  - name: AL Number Sequences Support in Cloud Migration
    status: unclear
    t: 424
    verified: false
    status_source: video
  - name: Reduced Table-to-Table Copy Threshold
    status: unclear
    t: 461
    verified: false
    status_source: video
  - name: Index Optimization for Table Copy
    status: unclear
    t: 499
    verified: false
    status_source: video
  - name: Bulk Copy Size Reduction
    status: unclear
    t: 550
    verified: false
    status_source: video
  - name: Diagnostic Runs Bulk Size Optimization
    status: unclear
    t: 585
    verified: false
    status_source: video
  - name: Extended Change Tracking Retention for Delta Sync
    status: unclear
    t: 627
    verified: false
    status_source: video
  - name: Extended Delta Sync Eligibility
    status: unclear
    t: 647
    verified: false
    status_source: video
  - name: Azure SQL Direct Database Linking
    status: unclear
    t: 668
    verified: false
    status_source: video
  - name: SQL Variant Type Support for Azure SQL
    status: unclear
    t: 708
    verified: false
    status_source: video
  - name: New Cloud Migration User Interface
    status: unclear
    t: 869
    verified: false
    status_source: video
  - name: Cloud migration failure drilling and visibility
    status: unclear
    t: 927
    verified: false
    status_source: video
  - name: Unblock table action
    status: unclear
    t: 1068
    verified: false
    status_source: video
  - name: Company and table status filtering
    status: unclear
    t: 1139
    verified: false
    status_source: video
  - name: Per-database table status verification
    status: unclear
    t: 1197
    verified: false
    status_source: video
  - name: Table detail search and exclusion explanation
    status: unclear
    t: 1289
    verified: false
    status_source: video
  - name: Complete cloud migration action with sanity check
    status: unclear
    t: 1341
    verified: false
    status_source: video
  - name: Pause and abandon cloud migration actions
    status: unclear
    t: 1382
    verified: false
    status_source: video
  - name: Sanitize tables action
    status: unclear
    t: 1440
    verified: false
    status_source: video
  - name: Move customized fields to table extensions
    status: unclear
    t: 1493
    verified: false
    status_source: video
  - name: Simplified UI for table mapping configuration
    status: unclear
    t: 1749
    verified: false
    status_source: video
  - name: Bulk table mapping selection
    status: unclear
    t: 1854
    verified: false
    status_source: video
  - name: Import and export of table mappings
    status: unclear
    t: 1922
    verified: false
    status_source: video
  - name: Programmatic table mapping via event subscription
    status: unclear
    t: 1937
    verified: false
    status_source: video
  - name: Cloud migration telemetry for partners
    status: unclear
    t: 2036
    verified: false
    status_source: video
  - name: Power BI dashboards for cloud migration monitoring
    status: unclear
    t: 2097
    verified: false
    status_source: video
  - name: Email notifications for cloud migration events
    status: unclear
    t: 2194
    verified: false
    status_source: video
  - name: Stopping direct upgrade path from version 14
    status: unclear
    t: 2265
    verified: false
    status_source: video
  - name: Obsolete object removal to clean up schema
    status: unclear
    t: 2301
    verified: false
    status_source: video
  - name: Early obsolete object removal feature
    status: unclear
    t: 2380
    verified: false
    status_source: video
  - name: Version jump strategy (jump builds every 5 versions)
    status: announced
    t: 2462
    verified: true
    status_source: video
  - name: Company batch size specification for cloud migration
    status: unclear
    t: 2672
    verified: false
    status_source: video
  - name: Include/exclude tables from cloud migration
    status: unclear
    t: 2692
    verified: false
    status_source: video
  - name: Delta sync for all-per database tables
    status: unclear
    t: 2754
    verified: false
    status_source: video
  - name: Optional intelligent Cloud permission set assignment
    status: unclear
    t: 2774
    verified: false
    status_source: video
  - name: Warning system for cloud migration
    status: unclear
    t: 2794
    verified: false
    status_source: video
  - name: Cancel ongoing replication action
    status: unclear
    t: 2831
    verified: false
    status_source: video
objects_mentioned:
  - other SQL change tracking
  - other AL number sequences
  - table customer
  - table G entry
  - table change log entry
  - table custom report layout
  - table report selections
  - table upgrade TXS
  - codeunit 4001
quotes:
  - t: 88
    text: the number of uh business Central tenants migrating their data from on premise has almost doubled last year comparing to the previous year and
    check: exact
  - t: 108
    text: back then we removed the hard limitation on the amount of the UN premis data that can be replicated to the cloud and that
    check: snapped
  - t: 382
    text: it has become possible to replicate an unlimited number of tables in a single migration run and we remove the limitation on the number
    check: exact
  - t: 444
    text: the AL number sequences data type is supported by Cloud migration and the numbering can continue in the BC tenant after migration instead of
    check: exact
  - t: 519
    text: our test measurement show 8 to 22% performance benefit for the new process comparing to the old way of inserting the data with all
    check: exact
  - t: 570
    text: the whole process of B copy became 60 to 80% faster
    check: exact
  - t: 668
    text: if uh Asia SQL is used a source it is possible to link the source and the destination Asia SQL databases directly without the
    check: snapped
  - t: 789
    text: the more powerful service tier you get the faster and smoother your Cloud migrations will be
    check: exact
  - t: 827
    text: it is extremely hard to get an overview which data has been moved and if there has been any problems with the cloud migration
    check: exact
  - t: 887
    text: we have decided to support both for the time being because we believe that some of you have done the customizations to the old
    check: exact
  - t: 1048
    text: now you're able to see which tables have failed the replication and which tables are requiring your attention immediately
    check: exact
  - t: 1088
    text: to enable you to be more efficient we have added this action which is called unblock the table
    check: exact
  - t: 1216
    text: tenant media if it was copied successfully it needs to have more records than there are in the on Prem database because we never
    check: exact
  - t: 1513
    text: we have shipped it with the version 21 actually because we backported the code to make it more efficient
    check: exact
  - t: 1566
    text: we are going to insert the default mapping by name and we are going to search for all of the fields that we can
    check: exact
  - t: 1581
    text: you are able to do the these simple migration table mappings and this will copy the custom fields to the Target table if the
    check: exact
  - t: 1601
    text: you need to rename the fields so you will need to prefix them so they are called the same as in on Prem
    check: exact
  - t: 1769
    text: we have added a dedicated UI for that and you can access it through this section which is called add table mappings
    check: exact
  - t: 1956
    text: if you do this through code then table mappings are going to be inserted each time when you complete the setup wizard or if
    check: exact
  - t: 2036
    text: approximately few weeks ago we have added support for the Telemetry and we have added a lot of events to the partner Telemetry
    check: exact
  - t: 2265
    text: we are stopping the direct upgrate and cloud migration po from version 14
    check: fuzzy
  - t: 2319
    text: we have 7 years of obsolete removed objects and these objects are taking around 10% of the database
    check: exact
  - t: 2360
    text: we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26 and we are
    check: exact
  - t: 2360
    text: we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26
    check: exact
  - t: 2441
    text: the only thing that you need to do to remove the table and the field from schema is to have a version in which
    check: exact
  - t: 2523
    text: in order to get to 26 you need to go through 25 so all of these on Prem versions they will need to upgrade
    check: exact
  - t: 2544
    text: we are planning to do these updates every five years so in every five versions We are planning to introduce a jumper build
    check: exact
  - t: 2622
    text: currently there are no plans of stopping the on Prem support and if there are any PLs they are going to be announced in
    check: exact
  - t: 2713
    text: if you would like to override this decision you need to do workarounds either to delete the content from the table or to use
    check: snapped
---

# What's New: Cloud Migration and Upgrade (2023)

> Cloud migration and upgrade changes from a 2023 Business Central session: faster replication (bulk copy, table-to-table copy, delta sync, Azure SQL direct linking), a new migration UI, customized-field-to-table-extension mapping, partner telemetry, and plans for the version 14 upgrade path and obsolete object removal.

[Watch on YouTube](https://www.youtube.com/watch?v=O921cRqXdiw) · Microsoft Dynamics 365 Business Central (YouTube) · 2023-11-21 · 49:07 · tier official · reviewed (checked by Opus)

## Overview

The session covers backend and UI changes to the cloud migration replication engine. Backend changes include storing replication metadata in a database table to bypass the 4 MB Data Factory limit, removing the limit on tables and companies per run, lowering the table-to-table copy threshold from 500 MB to 250 MB, disabling indexes during copy, smaller bulk sizes, longer change tracking retention, and direct linking of Azure SQL databases. Reported gains are 8 to 22 percent from index handling and 60 to 80 percent from bulk copy changes.

It then demos a new migration UI with failed-table drill-down, an unblock table action, company and table filtering, a complete-migration sanity check, and a sanitize tables action. It also shows moving customized fields to table extensions, telemetry and Power BI monitoring, and plans: stopping the direct upgrade path from version 14 after version 26, removing obsolete objects, and jump builds every 5 versions. Several items are described as not yet implemented and subject to change.

## Key points

- Replication metadata now goes through a database table instead of Data Factory parameters, so the number of tables and companies per run is no longer limited. Business Central still supports at most 300 companies per environment.
- The large-table threshold for optimized table-to-table copy dropped from 500 MB to 250 MB. Indexes are disabled during the copy and rebuilt afterward, which gave 8 to 22 percent in the speaker's tests.
- Smaller bulk sizes made bulk copy 60 to 80 percent faster. Timeouts can still happen on very weak or busy SQL servers.
- With Azure SQL as the source, the engine can link source and destination databases directly. This also allows SQL variant type fields to be replicated.
- The new UI shows failed tables, has an unblock table action, and blocks completion while failed tables exist. The old UI is still supported for existing customizations.
- Customized fields on Microsoft tables can be moved to table extensions through table mappings. Fields must be renamed to match the on-premises names. Partners can also supply mappings in code by subscribing to an event in codeunit 4001.
- Microsoft plans to stop the direct upgrade and cloud migration path from version 14 after version 26, about two years out. A jump build every 5 versions is announced and may change.

## Chapters

- [0:00](https://www.youtube.com/watch?v=O921cRqXdiw&t=0s) Introduction and Session Overview
- [1:08](https://www.youtube.com/watch?v=O921cRqXdiw&t=68s) Cloud Migration Usage Growth and Technical Challenges
- [2:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=149s) Replication Engine Architecture Overview
- [3:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=209s) Backend Improvements: Replication Pipelines and Data Copy Optimizations
- [5:51](https://www.youtube.com/watch?v=O921cRqXdiw&t=351s) Metadata Handling and Pipeline Improvements
- [8:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=482s) Table-to-Table Copy and Bulk Copy Optimizations
- [9:30](https://www.youtube.com/watch?v=O921cRqXdiw&t=570s) Diagnostic Runs and Delta Synchronization Improvements
- [11:08](https://www.youtube.com/watch?v=O921cRqXdiw&t=668s) Azure SQL Optimization and High-Volume Migration Recommendations
- [13:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=809s) Cloud Migration Performance and UI Redesign
- [15:27](https://www.youtube.com/watch?v=O921cRqXdiw&t=927s) New UI Status Overview and Failure Tracking
- [17:28](https://www.youtube.com/watch?v=O921cRqXdiw&t=1048s) Unblock Table Action and Migration Workflows
- [18:48](https://www.youtube.com/watch?v=O921cRqXdiw&t=1128s) Company and Table Status Filtering and Tenant Media Tables
- [21:17](https://www.youtube.com/watch?v=O921cRqXdiw&t=1277s) Data Exploration, Completion Actions, and Table Sanitization
- [24:53](https://www.youtube.com/watch?v=O921cRqXdiw&t=1493s) Customized Fields to Table Extensions Migration

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| Replication Pipeline Metadata Table Handling | status not stated | [6:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=362s) |  |
| Unlimited Tables and Companies in Single Migration Run | status not stated | [6:22](https://www.youtube.com/watch?v=O921cRqXdiw&t=382s) |  |
| Removed On-Premise Database Size Calculation from Replication Runs | status not stated | [6:42](https://www.youtube.com/watch?v=O921cRqXdiw&t=402s) |  |
| AL Number Sequences Support in Cloud Migration | status not stated | [7:04](https://www.youtube.com/watch?v=O921cRqXdiw&t=424s) |  |
| Reduced Table-to-Table Copy Threshold | status not stated | [7:41](https://www.youtube.com/watch?v=O921cRqXdiw&t=461s) |  |
| Index Optimization for Table Copy | status not stated | [8:19](https://www.youtube.com/watch?v=O921cRqXdiw&t=499s) |  |
| Bulk Copy Size Reduction | status not stated | [9:10](https://www.youtube.com/watch?v=O921cRqXdiw&t=550s) |  |
| Diagnostic Runs Bulk Size Optimization | status not stated | [9:45](https://www.youtube.com/watch?v=O921cRqXdiw&t=585s) |  |
| Extended Change Tracking Retention for Delta Sync | status not stated | [10:27](https://www.youtube.com/watch?v=O921cRqXdiw&t=627s) |  |
| Extended Delta Sync Eligibility | status not stated | [10:47](https://www.youtube.com/watch?v=O921cRqXdiw&t=647s) |  |
| Azure SQL Direct Database Linking | status not stated | [11:08](https://www.youtube.com/watch?v=O921cRqXdiw&t=668s) |  |
| SQL Variant Type Support for Azure SQL | status not stated | [11:48](https://www.youtube.com/watch?v=O921cRqXdiw&t=708s) |  |
| New Cloud Migration User Interface | status not stated, demoed | [14:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=869s) |  |
| Cloud migration failure drilling and visibility | status not stated, demoed | [15:27](https://www.youtube.com/watch?v=O921cRqXdiw&t=927s) |  |
| Unblock table action | status not stated, demoed | [17:48](https://www.youtube.com/watch?v=O921cRqXdiw&t=1068s) |  |
| Company and table status filtering | status not stated, demoed | [18:59](https://www.youtube.com/watch?v=O921cRqXdiw&t=1139s) |  |
| Per-database table status verification | status not stated, demoed | [19:57](https://www.youtube.com/watch?v=O921cRqXdiw&t=1197s) |  |
| Table detail search and exclusion explanation | status not stated, demoed | [21:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=1289s) |  |
| Complete cloud migration action with sanity check | status not stated, demoed | [22:21](https://www.youtube.com/watch?v=O921cRqXdiw&t=1341s) |  |
| Pause and abandon cloud migration actions | status not stated, demoed | [23:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=1382s) |  |
| Sanitize tables action | status not stated, demoed | [24:00](https://www.youtube.com/watch?v=O921cRqXdiw&t=1440s) |  |
| Move customized fields to table extensions | status not stated, demoed | [24:53](https://www.youtube.com/watch?v=O921cRqXdiw&t=1493s) |  |
| Simplified UI for table mapping configuration | status not stated, demoed | [29:09](https://www.youtube.com/watch?v=O921cRqXdiw&t=1749s) |  |
| Bulk table mapping selection | status not stated, demoed | [30:54](https://www.youtube.com/watch?v=O921cRqXdiw&t=1854s) |  |
| Import and export of table mappings | status not stated | [32:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=1922s) |  |
| Programmatic table mapping via event subscription | status not stated | [32:17](https://www.youtube.com/watch?v=O921cRqXdiw&t=1937s) |  |
| Cloud migration telemetry for partners | status not stated | [33:56](https://www.youtube.com/watch?v=O921cRqXdiw&t=2036s) |  |
| Power BI dashboards for cloud migration monitoring | status not stated, demoed | [34:57](https://www.youtube.com/watch?v=O921cRqXdiw&t=2097s) |  |
| Email notifications for cloud migration events | status not stated | [36:34](https://www.youtube.com/watch?v=O921cRqXdiw&t=2194s) |  |
| Stopping direct upgrade path from version 14 | status not stated | [37:45](https://www.youtube.com/watch?v=O921cRqXdiw&t=2265s) |  |
| Obsolete object removal to clean up schema | status not stated | [38:21](https://www.youtube.com/watch?v=O921cRqXdiw&t=2301s) |  |
| Early obsolete object removal feature | status not stated | [39:40](https://www.youtube.com/watch?v=O921cRqXdiw&t=2380s) |  |
| Version jump strategy (jump builds every 5 versions) | announced | [41:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=2462s) | "we are planning to do these updates every five years so in every five versions We are planning to introduce a jumper build" ([42:24](https://www.youtube.com/watch?v=O921cRqXdiw&t=2544s)) |
| Company batch size specification for cloud migration | status not stated | [44:32](https://www.youtube.com/watch?v=O921cRqXdiw&t=2672s) |  |
| Include/exclude tables from cloud migration | status not stated | [44:52](https://www.youtube.com/watch?v=O921cRqXdiw&t=2692s) |  |
| Delta sync for all-per database tables | status not stated | [45:54](https://www.youtube.com/watch?v=O921cRqXdiw&t=2754s) |  |
| Optional intelligent Cloud permission set assignment | status not stated | [46:14](https://www.youtube.com/watch?v=O921cRqXdiw&t=2774s) |  |
| Warning system for cloud migration | status not stated | [46:34](https://www.youtube.com/watch?v=O921cRqXdiw&t=2794s) |  |
| Cancel ongoing replication action | status not stated | [47:11](https://www.youtube.com/watch?v=O921cRqXdiw&t=2831s) |  |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- other "SQL change tracking" at [4:58](https://www.youtube.com/watch?v=O921cRqXdiw&t=298s)
- other "AL number sequences" at [7:24](https://www.youtube.com/watch?v=O921cRqXdiw&t=444s)
- [table 18 "Customer"](../objects/table/18.md) at [25:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=1529s)
- table "G entry" at [27:46](https://www.youtube.com/watch?v=O921cRqXdiw&t=1666s)
- [table 405 "Change Log Entry"](../objects/table/405.md) at [21:46](https://www.youtube.com/watch?v=O921cRqXdiw&t=1306s)
- [table 9650 "Custom Report Layout"](../objects/table/9650.md) at [20:16](https://www.youtube.com/watch?v=O921cRqXdiw&t=1216s)
- [table 77 "Report Selections"](../objects/table/77.md) at [20:16](https://www.youtube.com/watch?v=O921cRqXdiw&t=1216s)
- table "upgrade TXS" at [20:57](https://www.youtube.com/watch?v=O921cRqXdiw&t=1257s)
- codeunit "4001" at [32:36](https://www.youtube.com/watch?v=O921cRqXdiw&t=1956s)

Not found in BC28-30: table "G entry", table "upgrade TXS", codeunit "4001".

## Quotes

- [1:28](https://www.youtube.com/watch?v=O921cRqXdiw&t=88s) "the number of uh business Central tenants migrating their data from on premise has almost doubled last year comparing to the previous year and"
- [1:48](https://www.youtube.com/watch?v=O921cRqXdiw&t=108s) "back then we removed the hard limitation on the amount of the UN premis data that can be replicated to the cloud and that"
- [6:22](https://www.youtube.com/watch?v=O921cRqXdiw&t=382s) "it has become possible to replicate an unlimited number of tables in a single migration run and we remove the limitation on the number"
- [7:24](https://www.youtube.com/watch?v=O921cRqXdiw&t=444s) "the AL number sequences data type is supported by Cloud migration and the numbering can continue in the BC tenant after migration instead of"
- [8:39](https://www.youtube.com/watch?v=O921cRqXdiw&t=519s) "our test measurement show 8 to 22% performance benefit for the new process comparing to the old way of inserting the data with all"
- [9:30](https://www.youtube.com/watch?v=O921cRqXdiw&t=570s) "the whole process of B copy became 60 to 80% faster"
- [11:08](https://www.youtube.com/watch?v=O921cRqXdiw&t=668s) "if uh Asia SQL is used a source it is possible to link the source and the destination Asia SQL databases directly without the"
- [13:09](https://www.youtube.com/watch?v=O921cRqXdiw&t=789s) "the more powerful service tier you get the faster and smoother your Cloud migrations will be"
- [13:47](https://www.youtube.com/watch?v=O921cRqXdiw&t=827s) "it is extremely hard to get an overview which data has been moved and if there has been any problems with the cloud migration"
- [14:47](https://www.youtube.com/watch?v=O921cRqXdiw&t=887s) "we have decided to support both for the time being because we believe that some of you have done the customizations to the old"
- [17:28](https://www.youtube.com/watch?v=O921cRqXdiw&t=1048s) "now you're able to see which tables have failed the replication and which tables are requiring your attention immediately"
- [18:08](https://www.youtube.com/watch?v=O921cRqXdiw&t=1088s) "to enable you to be more efficient we have added this action which is called unblock the table"
- [20:16](https://www.youtube.com/watch?v=O921cRqXdiw&t=1216s) "tenant media if it was copied successfully it needs to have more records than there are in the on Prem database because we never"
- [25:13](https://www.youtube.com/watch?v=O921cRqXdiw&t=1513s) "we have shipped it with the version 21 actually because we backported the code to make it more efficient"
- [26:06](https://www.youtube.com/watch?v=O921cRqXdiw&t=1566s) "we are going to insert the default mapping by name and we are going to search for all of the fields that we can"
- [26:21](https://www.youtube.com/watch?v=O921cRqXdiw&t=1581s) "you are able to do the these simple migration table mappings and this will copy the custom fields to the Target table if the"
- [26:41](https://www.youtube.com/watch?v=O921cRqXdiw&t=1601s) "you need to rename the fields so you will need to prefix them so they are called the same as in on Prem"
- [29:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=1769s) "we have added a dedicated UI for that and you can access it through this section which is called add table mappings"
- [32:36](https://www.youtube.com/watch?v=O921cRqXdiw&t=1956s) "if you do this through code then table mappings are going to be inserted each time when you complete the setup wizard or if"
- [33:56](https://www.youtube.com/watch?v=O921cRqXdiw&t=2036s) "approximately few weeks ago we have added support for the Telemetry and we have added a lot of events to the partner Telemetry"
- [37:45](https://www.youtube.com/watch?v=O921cRqXdiw&t=2265s) "we are stopping the direct upgrate and cloud migration po from version 14"
- [38:39](https://www.youtube.com/watch?v=O921cRqXdiw&t=2319s) "we have 7 years of obsolete removed objects and these objects are taking around 10% of the database"
- [39:20](https://www.youtube.com/watch?v=O921cRqXdiw&t=2360s) "we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26 and we are"
- [39:20](https://www.youtube.com/watch?v=O921cRqXdiw&t=2360s) "we have received the request from the partners to ship the ability to remove the obsolete objects earlier before version 26"
- [40:41](https://www.youtube.com/watch?v=O921cRqXdiw&t=2441s) "the only thing that you need to do to remove the table and the field from schema is to have a version in which"
- [42:03](https://www.youtube.com/watch?v=O921cRqXdiw&t=2523s) "in order to get to 26 you need to go through 25 so all of these on Prem versions they will need to upgrade"
- [42:24](https://www.youtube.com/watch?v=O921cRqXdiw&t=2544s) "we are planning to do these updates every five years so in every five versions We are planning to introduce a jumper build"
- [43:42](https://www.youtube.com/watch?v=O921cRqXdiw&t=2622s) "currently there are no plans of stopping the on Prem support and if there are any PLs they are going to be announced in"
- [45:13](https://www.youtube.com/watch?v=O921cRqXdiw&t=2713s) "if you would like to override this decision you need to do workarounds either to delete the content from the table or to use"

## Disclaimers in the video

- [6:22](https://www.youtube.com/watch?v=O921cRqXdiw&t=382s) other: business Central supports not more than 300 companies in single environment
- [9:30](https://www.youtube.com/watch?v=O921cRqXdiw&t=570s) other: Timeouts may still happen for the extremely weak or busy SQL service
- [14:29](https://www.youtube.com/watch?v=O921cRqXdiw&t=869s) other: we have decided to support both for the time being because we believe that some of you have done the customizations to the old UI
- [20:16](https://www.youtube.com/watch?v=O921cRqXdiw&t=1216s) not-in-this-release: we do not have the warning system in place yet
- [27:21](https://www.youtube.com/watch?v=O921cRqXdiw&t=1641s) coming-later: we are planning to introduce name spaces and the goal of the development team is to eliminate prefixes and suffixes in all of the objects
- [37:45](https://www.youtube.com/watch?v=O921cRqXdiw&t=2265s) coming-later: we will need to stop this upgrade but this is in approximately two years
- [38:59](https://www.youtube.com/watch?v=O921cRqXdiw&t=2339s) subject-to-change: we are looking into this we have not started the implementation of this feature yet however the current thinking is
- [39:40](https://www.youtube.com/watch?v=O921cRqXdiw&t=2380s) preview: we have not started the implementation of this feature yet however the current thinking is that it is going to work like this
- [39:40](https://www.youtube.com/watch?v=O921cRqXdiw&t=2380s) coming-later: we have not started the implementation of this feature yet however the current thinking is that it is going to work like this
- [43:21](https://www.youtube.com/watch?v=O921cRqXdiw&t=2601s) subject-to-change: this thing that you have just seen is our current thinking and these are the things that we are planning to do with the current knowledge
- [44:02](https://www.youtube.com/watch?v=O921cRqXdiw&t=2642s) subject-to-change: this current schedule that you have seen it can change and in case of any changes we are also going to announce it to you

Presenters (as heard): Nicola, Julia.