Create Migration Script

This tool will help you to create an SQL script to move the data from the "Anvaigo EDI Connect - On Premise" version of the module to the Universal Code ready "Anvaigo EDI Connect" version.

Universal Code does not support the same feature set as our OnPremise app. In particular, direct file system access and the (deprecated) remote components are not available. As a replacement, the File Exchange Service (FES) can be used.

Make sure you have upgraded the OnPremise app to a version that can be selected in the version list below. If you have to upgrade the extension make sure to upgrade the tenant data and sync the schemas and restart the service tier, if required.
To upgrade publish the new Universal Code extension to the Business Central system but do not install it
Create the SQL script by filling out the form below and open it in an editor.
Start the SQL Management Studio and connect to the server.
The user running the script must own the tables or have ALTER privileges on the ANVEDI... tables on the SQL server.
Make sure to select the correct database and create a new script. Paste the code from the script generated by this page and run it.
Uninstall the "Anvaigo EDI Connect - On Premise" extension in BC. Keep the data to be safe.
Install the universal code application. You should have all the data from the other version.

Please make a database backup and test the function in a test system before you run the generated script on a production environment. The script will delete any existing data in the universal Code extension. We have tested the script extensively, however we disclaim any liability in case of database problems and/or data loss. It is the responsibility of the person running the script to ensure that there is no data loss or failure.

We need the following values:

Anvaigo EDI Connect Version:

Please make sure that the Anvaigo EDI Connect - On Premise version as well as the Anvaigo EDI Connect (Universal Code version) extension is published and that they have the same version number. The version is important to make sure that the columns in all the tables are the same.

Database Name:

Search for the ANVEDI tables in SQL Management Studio on the Business Central database. Copy the database part. E.g. "dbo.CRONUS International Ltd_$ANV EDIFACT_X12 Code List$25286bd2-b08a-49f9-b613-64122ccee4e1"

Company Name:

This is the SQL representation of the company name inside BC. We need it in the format that is shown in the SQL Management Studio. E.g. "dbo.CRONUS International Ltd_$ANV EDIFACT_X12 Code List$25286bd2-b08a-49f9-b613-64122ccee4e1"