Import/Export

In this article, you will learn how to import and export the setup of an database assignment in the Aident SQL Migration app in Business Central.

What's the purpose of the function?

The import and export functionality makes it possible to import and export the settings of a database assignment including the company assignments, table assignments, table part assignments and field assignments.

Export Assignment

Follow these steps to export a database assignment:

1. Navigate to Database Assignments
   • In Business Central, search for and go to the Database Assignments page.
2. Open Database Assignment
   • Open the database assignment for which the setup should be exported. The Database Assignment Card page opens.
3. Export Database Assignment
   • Click Export Assignment in the Related action menu in the context menu Export/Import to start the export.
   • The file SQL_Assignment-<<DatabaseAssignmentCode>>.json is created and exported. You can import this file for future migration projects.

Import Assignment

Follow these steps to export a database assignment:

1. Navigate to Database Assignments
   • In Business Central, search for and go to the Database Assignments page.
2. Open Database Assignment
   • Open the database assignment for which the setup should be exported. The Database Assignment Card page opens.
3. Import Database Assignment
   • Click Import Assignment in the Related action menu in the context menu Export/Import to start the import. The Upload: JSON Files (*.json) page opens. Then select a JSON file for import.
   • The file is then processed and a new database assignment including the company assignments, table assignments, table part assignments and field assignments is created. If a database assignment with the same code already exists, it can be overwritten.