How to Upgrade the Data from C/AL to AL Tables in Microsoft Dynamics Business Central Wave 2

With the Business Central’s new Wave 2 release, and the C/AL objects been eliminated, All we have with us now is the AL Code and former Base C/AL Codes incorporated inside an App.

This raises a question in everyone’s mind that how can this data lying in the C/AL tables be taken forward to AL Tables present in the Base App while Upgrading. We cannot leave the data behind so obviously Microsoft has given us a way to take our data to the new environment.

To support this data migration, we need to Rename the tables by adding the AL extension’s AppID as a part of table names.

After renaming the table names, using the Powershell cmdlet Sync-NAVApp, we can convert all the 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 simple process corresponds to the technical platform upgrade for a tenant. It basically brings the table structure from the base application to the table structure for extensions.

If you are facing any problems with the Data Upgrade in Wave 2, then please raise your concerns here.

Thanks for Reading!