---
id: video/lCXrKdxneKo
type: video
title: Introduction to Business Central Cloud Migration Tooling (2022)
summary: Business Central cloud migration tooling from on-premises to Business Central online, using Azure Data Factory and a self-hosted integration runtime. It is evidence for preparation (table alignment, data cleanup), setup and permissions, troubleshooting, table mapping, the new upgrade flow and migration APIs.
tier: official
language: en
tags:
  - cloud migration
  - upgrade
  - data replication
  - table mapping
  - azure data factory
  - corrupted fields
  - data cleanup
  - self-hosted integration runtime
  - on-premises to cloud
  - sql server
  - connection strings
  - stored procedures
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:15:26.284Z"
  flags: []
generated:
  at: "2026-10-07T23:15:26.326Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 9796e7616b1435c77992748dac1553edc731606ea458970e0257b10542897ffc
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=136s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 136
    quote: version 14 and this is a rather important version because this is the last version which is supporting CR
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=197s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 197
    quote: you can do a single step upgrad to the version 21 skipping all of the versions in between
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=291s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 291
    quote: we are going to support this part as long as we technically can because we want to make you as efficient when you're running
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=368s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 368
    quote: in the last 30 days we had 564 unique customers migrating
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=433s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 433
    quote: these properties are must for both Cloud migration and for operate so you must align primary keys
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=493s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 493
    quote: the cloud migration is going to ignore these fields currently so we will replicate the Full Table ignoring the fields that you have added
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=493s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 493
    quote: we have a prototype that we are currently testing so we believe that during the cloud migration we will be able to split the
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=794s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 794
    quote: self hosted integration runtime and this is installed within the network of the customer on prem and then registered with our azure data
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=828s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 828
    quote: there is no NST needed no NST running needed um we really connect directly to the database
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1040s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1040
    quote: the user that is doing the setup in BC has to have the super role
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1534s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1534
    quote: we won't move all the data but only those that are Delta change so incremental uh that would make it faster
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1534s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1534
    quote: it's important that you do not replace or you don't change your on premise database otherwise the change tracking becomes invalid
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1555s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1555
    quote: the replication is done by Asia data Factory and it's mostly very stable we don't see so many errors
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1615s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1615
    quote: you keep the machine that hosts your integration run time online all the time while you're doing Cloud migration
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1648s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1648
    quote: these are the most difficult errors that you face they're not very common there are like maybe 10 errors per months
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1688s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1688
    quote: Asia data Factory has a limitation for this text description to be less than four megabytes
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=1740s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 1740
    quote: we suggest that you kind of uh reduce the number of companies for migration you can do it on cloud migration management page
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2015s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2015
    quote: an optimal size is about 10 15 companies it could be more it depends on your data
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2035s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2035
    quote: we just copy them but we copy them because the SQL names match so we look at the SQL names and that usually the
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2191s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2191
    quote: we are leveraging the upgrade Logic for the up if your Cloud migrating from previous versions
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2251s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2251
    quote: we are triggering the full upgrade code all apps are going to be included and you will have a single upgrate Logic
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2292s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2292
    quote: you can track the status in the admin Center so if you say yes you will get the message that the upgrade was scheduled
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2372s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2372
    quote: you'll get a full stack Trace we are looking into providing you with a nice error message message as well so you can see
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2412s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2412
    quote: so now you can fix the errors replicate additional data or try to run the upgrade again so with this new flow you're also
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2425s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2425
    quote: because we are just rolling this one out we are still supporting the old upgrade flow so if you took any dependencies to how
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2487s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2487
    quote: if you want to update 1 million entries it's going to take anywhere between 2 hours or 24 hours and more the reason why
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2527s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2527
    quote: with data transfer one to million entries is approximately taking two to 5 minutes so with this feature now we are able to update
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2580s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2580
    quote: currently it's marked as Target on Prem which means that you will unfortunately not be able to use it for SAS solution but you
  - kind: video
    url: https://www.youtube.com/watch?v=lCXrKdxneKo&t=2593s
    title: Introduction to Business Central Cloud Migration Tooling (2022)
    date: "2023-11-21T16:04:26.000Z"
    commit: null
    t: 2593
    quote: for this release we have shrinked the number of long running methods by 11 because we use this new data transfer feature to optimize
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: lCXrKdxneKo
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=lCXrKdxneKo
published_at: "2023-11-21T16:04:26.000Z"
duration_s: 2759
captions: full
audience:
  - administrator
  - developer
  - functional consultant
  - partner
chapters:
  - t: 0
    title: Introduction and Session Overview
  - t: 116
    title: Cloud Migration Journey and Version History
  - t: 271
    title: Support Timeline and Migration Statistics
  - t: 401
    title: "Pre-Migration Preparation: Table Definitions and Alignment"
  - t: 553
    title: Data Cleanup and Sanitization
  - t: 694
    title: Cloud Migration Architecture and Pipeline Creation
  - t: 988
    title: Common Setup Errors and Troubleshooting
  - t: 1242
    title: SQL Connection Issues and Migration Execution
  - t: 1457
    title: Replication Optimizations and Troubleshooting
  - t: 1668
    title: Metadata Limitations and Extension Management
  - t: 1862
    title: Data Migration Errors and Performance Optimization
  - t: 2015
    title: Data Mapping and Table Migration Strategies
  - t: 2157
    title: Upgrade Process and Tenant Management
  - t: 2372
    title: Upgrade Failure Recovery and Data Transfer
  - t: 2580
    title: API Automation and Performance Improvements
features:
  - name: Cloud Migration Tooling
    status: unclear
    t: 55
    verified: false
    status_source: video
  - name: One-Step Upgrade to Version 21
    status: unclear
    t: 197
    verified: false
    status_source: video
  - name: Direct Cloud Migration from Version 14
    status: unclear
    t: 237
    verified: false
    status_source: video
  - name: Table Extension Auto-Refactoring
    status: unclear
    t: 493
    verified: false
    status_source: video
  - name: Invoke-NavSanitizeField Commandlet
    status: unclear
    t: 564
    verified: false
    status_source: video
  - name: Table Mapping for Cloud Migration
    status: unclear
    t: 453
    verified: false
    status_source: video
  - name: Azure Data Factory Integration for Migration
    status: unclear
    t: 713
    verified: false
    status_source: video
  - name: Self-Hosted Integration Runtime
    status: unclear
    t: 774
    verified: false
    status_source: video
  - name: Cloud Migration Wizard
    status: unclear
    t: 866
    verified: false
    status_source: video
  - name: Preparation Pipeline
    status: unclear
    t: 917
    verified: false
    status_source: video
  - name: Replication Pipeline
    status: unclear
    t: 967
    verified: false
    status_source: video
  - name: User Permissions Validation
    status: unclear
    t: 1023
    verified: false
    status_source: video
  - name: SQL Connection String Validation
    status: unclear
    t: 1081
    verified: false
    status_source: video
  - name: Database Query Performance Optimization
    status: unclear
    t: 1150
    verified: false
    status_source: video
  - name: Version Matching Validation
    status: unclear
    t: 1192
    verified: false
    status_source: video
  - name: SQL Connection Verification
    status: unclear
    t: 1242
    verified: false
    status_source: video
  - name: Migration Run Execution
    status: unclear
    t: 1341
    verified: false
    status_source: video
  - name: Data Compression and Two-Step Transfer
    status: unclear
    t: 1381
    verified: false
    status_source: video
  - name: Large Table Replication
    status: unclear
    t: 1423
    verified: false
    status_source: video
  - name: Small Table Optimization
    status: unclear
    t: 1457
    verified: false
    status_source: video
  - name: Full and Incremental Replication
    status: unclear
    t: 1514
    verified: false
    status_source: video
  - name: Integration Runtime Offline Handling
    status: unclear
    t: 1595
    verified: false
    status_source: video
  - name: Database Replacement Impact
    status: unclear
    t: 1635
    verified: false
    status_source: video
  - name: Metadata size limitations
    status: unclear
    t: 1668
    verified: false
    status_source: video
  - name: Multi-company migration optimization
    status: unclear
    t: 1720
    verified: false
    status_source: video
  - name: Extension cleanup for migration
    status: unclear
    t: 1760
    verified: false
    status_source: video
  - name: Table-level replication exclusion
    status: unclear
    t: 1780
    verified: false
    status_source: video
  - name: Tenant media bulk copy handling
    status: unclear
    t: 1820
    verified: false
    status_source: video
  - name: Table-to-table full copy error handling
    status: unclear
    t: 1882
    verified: false
    status_source: video
  - name: On-premises infrastructure monitoring
    status: unclear
    t: 1938
    verified: false
    status_source: video
  - name: Database statistics and index optimization
    status: unclear
    t: 1958
    verified: false
    status_source: video
  - name: Default data mapping for table replication
    status: unclear
    t: 2015
    verified: false
    status_source: video
  - name: Missing table warning during replication
    status: unclear
    t: 2056
    verified: false
    status_source: video
  - name: Table mapping for different table names
    status: unclear
    t: 2116
    verified: false
    status_source: video
  - name: Improved upgrade logic for cloud migration
    status: unclear
    t: 2191
    verified: false
    status_source: video
  - name: Single-session upgrade with full app inclusion
    status: unclear
    t: 2231
    verified: false
    status_source: video
  - name: Upgrade status tracking in Admin Center
    status: unclear
    t: 2272
    verified: false
    status_source: video
  - name: Automatic point-in-time restore on upgrade failure
    status: unclear
    t: 2372
    verified: false
    status_source: video
  - name: Legacy upgrade flow support
    status: unclear
    t: 2412
    verified: false
    status_source: video
  - name: Data transfer feature
    status: unclear
    t: 2446
    verified: false
    status_source: video
  - name: Long-running methods optimization
    status: unclear
    t: 2593
    verified: false
    status_source: video
  - name: Cloud migration APIs
    status: unclear
    t: 2654
    verified: false
    status_source: video
objects_mentioned:
  - other Invoke-NavSanitizeField
  - page data archive page
  - table cloud migration management
  - table tenant media
  - other is full copy
quotes:
  - t: 136
    text: version 14 and this is a rather important version because this is the last version which is supporting CR
    check: exact
  - t: 197
    text: you can do a single step upgrad to the version 21 skipping all of the versions in between
    check: exact
  - t: 291
    text: we are going to support this part as long as we technically can because we want to make you as efficient when you're running
    check: exact
  - t: 368
    text: in the last 30 days we had 564 unique customers migrating
    check: exact
  - t: 433
    text: these properties are must for both Cloud migration and for operate so you must align primary keys
    check: exact
  - t: 493
    text: the cloud migration is going to ignore these fields currently so we will replicate the Full Table ignoring the fields that you have added
    check: exact
  - t: 493
    text: we have a prototype that we are currently testing so we believe that during the cloud migration we will be able to split the
    check: exact
  - t: 794
    text: self hosted integration runtime and this is installed within the network of the customer on prem and then registered with our azure data
    check: fuzzy
  - t: 828
    text: there is no NST needed no NST running needed um we really connect directly to the database
    check: exact
  - t: 1040
    text: the user that is doing the setup in BC has to have the super role
    check: exact
  - t: 1534
    text: we won't move all the data but only those that are Delta change so incremental uh that would make it faster
    check: exact
  - t: 1534
    text: it's important that you do not replace or you don't change your on premise database otherwise the change tracking becomes invalid
    check: exact
  - t: 1555
    text: the replication is done by Asia data Factory and it's mostly very stable we don't see so many errors
    check: exact
  - t: 1615
    text: you keep the machine that hosts your integration run time online all the time while you're doing Cloud migration
    check: exact
  - t: 1648
    text: these are the most difficult errors that you face they're not very common there are like maybe 10 errors per months
    check: exact
  - t: 1688
    text: Asia data Factory has a limitation for this text description to be less than four megabytes
    check: exact
  - t: 1740
    text: we suggest that you kind of uh reduce the number of companies for migration you can do it on cloud migration management page
    check: exact
  - t: 2015
    text: an optimal size is about 10 15 companies it could be more it depends on your data
    check: exact
  - t: 2035
    text: we just copy them but we copy them because the SQL names match so we look at the SQL names and that usually the
    check: exact
  - t: 2191
    text: we are leveraging the upgrade Logic for the up if your Cloud migrating from previous versions
    check: snapped
  - t: 2251
    text: we are triggering the full upgrade code all apps are going to be included and you will have a single upgrate Logic
    check: exact
  - t: 2292
    text: you can track the status in the admin Center so if you say yes you will get the message that the upgrade was scheduled
    check: exact
  - t: 2372
    text: you'll get a full stack Trace we are looking into providing you with a nice error message message as well so you can see
    check: exact
  - t: 2412
    text: so now you can fix the errors replicate additional data or try to run the upgrade again so with this new flow you're also
    check: exact
  - t: 2425
    text: because we are just rolling this one out we are still supporting the old upgrade flow so if you took any dependencies to how
    check: exact
  - t: 2487
    text: if you want to update 1 million entries it's going to take anywhere between 2 hours or 24 hours and more the reason why
    check: exact
  - t: 2527
    text: with data transfer one to million entries is approximately taking two to 5 minutes so with this feature now we are able to update
    check: snapped
  - t: 2580
    text: currently it's marked as Target on Prem which means that you will unfortunately not be able to use it for SAS solution but you
    check: exact
  - t: 2593
    text: for this release we have shrinked the number of long running methods by 11 because we use this new data transfer feature to optimize
    check: exact
---

# Introduction to Business Central Cloud Migration Tooling (2022)

> Business Central cloud migration tooling from on-premises to Business Central online, using Azure Data Factory and a self-hosted integration runtime. It is evidence for preparation (table alignment, data cleanup), setup and permissions, troubleshooting, table mapping, the new upgrade flow and migration APIs.

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

## Overview

The session covers the cloud migration journey from on-premises Business Central, including the one-step upgrade from version 14 to version 21 and the option to replicate directly to the cloud. It explains the architecture: a wizard in the destination environment, a preparation pipeline and a replication pipeline in Azure Data Factory, and a self-hosted integration runtime that copies data through regional blob storage to the tenant database.

The presenters also cover common errors and fixes. Topics include connection strings, permissions, the 4 MB metadata limit, out-of-memory and row delimiter errors, and database replacement during replication. The session then covers table mapping, the new upgrade flow with automatic point-in-time restore, the data transfer feature for upgrades, and cloud migration APIs for bulk automation.

## Key points

- From version 14 you can do a single-step upgrade to version 21 on-premises and then replicate, or replicate straight from 14 to the cloud and let the cloud run the upgrade. Microsoft says it will support the 14 path as long as it technically can.
- Table definitions must be aligned, including primary keys, field names and data types. Custom fields added to standard tables are ignored during migration unless they are refactored into extensions. Extra on-premises fields are silently ignored with no warnings. A prototype to split them into table extensions automatically was being tested.
- Run the Invoke-NavSanitizeField commandlet before production migration to fix corrupted code fields. It does not cover company names, which are text fields. Those must be detected with a query and renamed before migration.
- The self-hosted integration runtime needs .NET 4.72 or higher and must stay online during migration. A long offline period can trigger automated cleanup of Azure resources and force setup to be repeated. No NST is needed.
- Setup needs the super role in BC, and customer consent if the user is a delegated admin. The SQL user needs the sysadmin server role (captioned as 'CIS admin') and the db owner role. Connection strings must match the exact documented format.
- Metadata errors come from a 4 MB Azure Data Factory limit. Reduce the companies migrated at once (about 10 to 15 is suggested, depending on data and extensions) and uninstall unneeded extensions in the cloud tenant before migrating.
- The first run is a full replication, and later runs are incremental through SQL change tracking. Do not replace or restore the on-premises database during migration. It causes invalid object name errors and invalidates change tracking, which forces a full replication again.

## Chapters

- [0:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=0s) Introduction and Session Overview
- [1:56](https://www.youtube.com/watch?v=lCXrKdxneKo&t=116s) Cloud Migration Journey and Version History
- [4:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=271s) Support Timeline and Migration Statistics
- [6:41](https://www.youtube.com/watch?v=lCXrKdxneKo&t=401s) Pre-Migration Preparation: Table Definitions and Alignment
- [9:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=553s) Data Cleanup and Sanitization
- [11:34](https://www.youtube.com/watch?v=lCXrKdxneKo&t=694s) Cloud Migration Architecture and Pipeline Creation
- [16:28](https://www.youtube.com/watch?v=lCXrKdxneKo&t=988s) Common Setup Errors and Troubleshooting
- [20:42](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1242s) SQL Connection Issues and Migration Execution
- [24:17](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1457s) Replication Optimizations and Troubleshooting
- [27:48](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1668s) Metadata Limitations and Extension Management
- [31:02](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1862s) Data Migration Errors and Performance Optimization
- [33:35](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2015s) Data Mapping and Table Migration Strategies
- [35:57](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2157s) Upgrade Process and Tenant Management
- [39:32](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2372s) Upgrade Failure Recovery and Data Transfer
- [43:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2580s) API Automation and Performance Improvements

## Features

| Feature | Status | At |
|---|---|---|
| Cloud Migration Tooling | status not stated, demoed | [0:55](https://www.youtube.com/watch?v=lCXrKdxneKo&t=55s) |
| One-Step Upgrade to Version 21 | status not stated | [3:17](https://www.youtube.com/watch?v=lCXrKdxneKo&t=197s) |
| Direct Cloud Migration from Version 14 | status not stated | [3:57](https://www.youtube.com/watch?v=lCXrKdxneKo&t=237s) |
| Table Extension Auto-Refactoring | status not stated | [8:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=493s) |
| Invoke-NavSanitizeField Commandlet | status not stated | [9:24](https://www.youtube.com/watch?v=lCXrKdxneKo&t=564s) |
| Table Mapping for Cloud Migration | status not stated, demoed | [7:33](https://www.youtube.com/watch?v=lCXrKdxneKo&t=453s) |
| Azure Data Factory Integration for Migration | status not stated, demoed | [11:53](https://www.youtube.com/watch?v=lCXrKdxneKo&t=713s) |
| Self-Hosted Integration Runtime | status not stated, demoed | [12:54](https://www.youtube.com/watch?v=lCXrKdxneKo&t=774s) |
| Cloud Migration Wizard | status not stated | [14:26](https://www.youtube.com/watch?v=lCXrKdxneKo&t=866s) |
| Preparation Pipeline | status not stated | [15:17](https://www.youtube.com/watch?v=lCXrKdxneKo&t=917s) |
| Replication Pipeline | status not stated | [16:07](https://www.youtube.com/watch?v=lCXrKdxneKo&t=967s) |
| User Permissions Validation | status not stated | [17:03](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1023s) |
| SQL Connection String Validation | status not stated | [18:01](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1081s) |
| Database Query Performance Optimization | status not stated | [19:10](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1150s) |
| Version Matching Validation | status not stated | [19:52](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1192s) |
| SQL Connection Verification | status not stated | [20:42](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1242s) |
| Migration Run Execution | status not stated | [22:21](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1341s) |
| Data Compression and Two-Step Transfer | status not stated | [23:01](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1381s) |
| Large Table Replication | status not stated | [23:43](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1423s) |
| Small Table Optimization | status not stated | [24:17](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1457s) |
| Full and Incremental Replication | status not stated | [25:14](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1514s) |
| Integration Runtime Offline Handling | status not stated | [26:35](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1595s) |
| Database Replacement Impact | status not stated | [27:15](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1635s) |
| Metadata size limitations | status not stated | [27:48](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1668s) |
| Multi-company migration optimization | status not stated, demoed | [28:40](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1720s) |
| Extension cleanup for migration | status not stated | [29:20](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1760s) |
| Table-level replication exclusion | status not stated | [29:40](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1780s) |
| Tenant media bulk copy handling | status not stated | [30:20](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1820s) |
| Table-to-table full copy error handling | status not stated | [31:22](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1882s) |
| On-premises infrastructure monitoring | status not stated | [32:18](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1938s) |
| Database statistics and index optimization | status not stated | [32:38](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1958s) |
| Default data mapping for table replication | status not stated | [33:35](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2015s) |
| Missing table warning during replication | status not stated | [34:16](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2056s) |
| Table mapping for different table names | status not stated, demoed | [35:16](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2116s) |
| Improved upgrade logic for cloud migration | status not stated | [36:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2191s) |
| Single-session upgrade with full app inclusion | status not stated | [37:11](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2231s) |
| Upgrade status tracking in Admin Center | status not stated, demoed | [37:52](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2272s) |
| Automatic point-in-time restore on upgrade failure | status not stated, demoed | [39:32](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2372s) |
| Legacy upgrade flow support | status not stated | [40:12](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2412s) |
| Data transfer feature | status not stated | [40:46](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2446s) |
| Long-running methods optimization | status not stated | [43:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2593s) |
| Cloud migration APIs | status not stated | [44:14](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2654s) |

## 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 "Invoke-NavSanitizeField" at [10:22](https://www.youtube.com/watch?v=lCXrKdxneKo&t=622s)
- page "data archive page" at [11:14](https://www.youtube.com/watch?v=lCXrKdxneKo&t=674s)
- table "cloud migration management" at [29:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1740s)
- table "tenant media" at [30:41](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1841s)
- other "is full copy" at [31:22](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1882s)

Not found in BC28-30: page "data archive page", table "cloud migration management", table "tenant media".

## Quotes

- [2:16](https://www.youtube.com/watch?v=lCXrKdxneKo&t=136s) "version 14 and this is a rather important version because this is the last version which is supporting CR"
- [3:17](https://www.youtube.com/watch?v=lCXrKdxneKo&t=197s) "you can do a single step upgrad to the version 21 skipping all of the versions in between"
- [4:51](https://www.youtube.com/watch?v=lCXrKdxneKo&t=291s) "we are going to support this part as long as we technically can because we want to make you as efficient when you're running"
- [6:08](https://www.youtube.com/watch?v=lCXrKdxneKo&t=368s) "in the last 30 days we had 564 unique customers migrating"
- [7:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=433s) "these properties are must for both Cloud migration and for operate so you must align primary keys"
- [8:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=493s) "the cloud migration is going to ignore these fields currently so we will replicate the Full Table ignoring the fields that you have added"
- [8:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=493s) "we have a prototype that we are currently testing so we believe that during the cloud migration we will be able to split the"
- [13:14](https://www.youtube.com/watch?v=lCXrKdxneKo&t=794s) "self hosted integration runtime and this is installed within the network of the customer on prem and then registered with our azure data"
- [13:48](https://www.youtube.com/watch?v=lCXrKdxneKo&t=828s) "there is no NST needed no NST running needed um we really connect directly to the database"
- [17:20](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1040s) "the user that is doing the setup in BC has to have the super role"
- [25:34](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1534s) "we won't move all the data but only those that are Delta change so incremental uh that would make it faster"
- [25:34](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1534s) "it's important that you do not replace or you don't change your on premise database otherwise the change tracking becomes invalid"
- [25:55](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1555s) "the replication is done by Asia data Factory and it's mostly very stable we don't see so many errors"
- [26:55](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1615s) "you keep the machine that hosts your integration run time online all the time while you're doing Cloud migration"
- [27:28](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1648s) "these are the most difficult errors that you face they're not very common there are like maybe 10 errors per months"
- [28:08](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1688s) "Asia data Factory has a limitation for this text description to be less than four megabytes"
- [29:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=1740s) "we suggest that you kind of uh reduce the number of companies for migration you can do it on cloud migration management page"
- [33:35](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2015s) "an optimal size is about 10 15 companies it could be more it depends on your data"
- [33:55](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2035s) "we just copy them but we copy them because the SQL names match so we look at the SQL names and that usually the"
- [36:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2191s) "we are leveraging the upgrade Logic for the up if your Cloud migrating from previous versions"
- [37:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2251s) "we are triggering the full upgrade code all apps are going to be included and you will have a single upgrate Logic"
- [38:12](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2292s) "you can track the status in the admin Center so if you say yes you will get the message that the upgrade was scheduled"
- [39:32](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2372s) "you'll get a full stack Trace we are looking into providing you with a nice error message message as well so you can see"
- [40:12](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2412s) "so now you can fix the errors replicate additional data or try to run the upgrade again so with this new flow you're also"
- [40:25](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2425s) "because we are just rolling this one out we are still supporting the old upgrade flow so if you took any dependencies to how"
- [41:27](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2487s) "if you want to update 1 million entries it's going to take anywhere between 2 hours or 24 hours and more the reason why"
- [42:07](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2527s) "with data transfer one to million entries is approximately taking two to 5 minutes so with this feature now we are able to update"
- [43:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2580s) "currently it's marked as Target on Prem which means that you will unfortunately not be able to use it for SAS solution but you"
- [43:13](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2593s) "for this release we have shrinked the number of long running methods by 11 because we use this new data transfer feature to optimize"

## Disclaimers in the video

- [4:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=271s) subject-to-change: we are going to support this part as long as we technically can
- [8:33](https://www.youtube.com/watch?v=lCXrKdxneKo&t=513s) preview: we have a prototype that we are currently testing so we believe that during the cloud migration we will be able to split the main table with table extensions into main table and table extension without the need for you to write any code and if we are successful we are going to announce it so just keep your eyes open there might be an announcement coming in a few weeks
- [36:31](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2191s) preview: we are just rolling this one out we are still supporting the old upgrade flow
- [40:46](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2446s) other: I will not be able to talk about it much I will just briefly cover it
- [42:39](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2559s) other: it has some limitations because it's a very powerful feature
- [43:00](https://www.youtube.com/watch?v=lCXrKdxneKo&t=2580s) preview: currently it's marked as Target on Prem

Presenters (as heard): Nicola, Roman, Julia, Yia.