Support for performant data upgrade from C/AL tables to AL tables


This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Aug 1, 2019 This feature is released. Oct 1, 2019

Business value

When converting customers with on-premises C/AL code customized solutions to an AL-based solution, data must be carried forward from the former to the latter as part of the upgrade process.

Feature details

When you convert C/AL to AL code customizations, such as the conversion of the Business Central base application to AL, there will likely be a need to transfer data for existing customers from "old C/AL" tables to "new AL" tables. To support this, we rename tables by adding the AL extension's AppId as part of the table names.

Using the PowerShell cmdlet Sync-NAVApp, partners can convert all C/AL tables to AL tables with minimal database overhead and without the need to write any upgrade code. The command Sync-NAVApp -Mode BaseAppUpgrade renames tables on the tenant database to conform to the naming convention for AL tables. This corresponds to the technical platform upgrade for a tenant, bringing the table structure from the base application to the table structure for extensions.

See also

Upgrading to Business Central 2019 Release Wave 2 (docs)