Table of Contents

Fixed Name Conversion

In this article, you will learn how to create and use fixed name conversions in the Aident SQL Migration app in Business Central.

What's the purpose of the function?

For extensions in Business Central, it is necessary that they're provided with a prefix or a suffix. This leads to necessary adjustments to the table and field names. It's also possible that a table receives a new ID. These changes ensure that the automatic assignment of tables and fields doesn't work correctly, since these assignments are made based on the table ID (for table assignments) or the field name (for field assignments).

By setting up a fixed table name conversion or a fixed field name conversion, the automatic assignment can still take place using the Aident SQL Migration app.

Enable Name Conversions

Follow these steps to Enable the Name Conversion feature:

  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 a table name conversion should be created. The Database Assignment Card page opens.
  3. Set Use fixed Name Conversion
    • Set Use fixed Name Conversion to true in the General FastTab.

Create Table Name Conversions

Follow these steps to create Table Name Conversion records:

  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 a name conversion should be created. The Database Assignment Card page opens.
  3. Open Table Name Conversions
    • Click Table Name Conversion in the Related action menu. The Table Name Conversions page opens.
  4. Create Table Name Conversion records
    • Enter Destination Table ID and Destination Table Name and the corresponding Source Table ID and Source Table Name.

Export Table Name Conversions

Follow these steps to export Table Name Conversion records:

  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 a table name conversion should be exported. The Database Assignment Card page opens.
  3. Open Table Name Conversions
    • Click Table Name Conversion in the Related action menu. The Table Name Conversions page opens.
  4. Export Table Name Conversion records
    • Click Export to JSON in the action bar.
  5. Set Filter
    • Set a filter for e.g. Destination Table ID to determine which table name conversion records should be exported. If no filters are set, all table name conversion records are exported.
  6. Start Export
    • Click OK to start the export. The file SQL_TableNameConversion.json is created and exported. You can import this file for future migration projects.

Import Table Name Conversions

Follow these steps to import Table Name Conversion records:

  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 a table name conversion should be imported. The Database Assignment Card page opens.
  3. Open Table Name Conversions
    • Click Table Name Conversion in the Related action menu. The Table Name Conversions page opens.
  4. Import Table Name Conversion records
    • Click Import from JSON in the action bar. The Import Json File page opens. Then select a JSON file for import.
  5. Set Filter
    • Set a filter for e.g. Destination Table ID to determine which table name conversion records should be imported. If no filters are set, all lines are imported.
  6. Start Import
    • Click OK to start the import. Existing records will be overwritten.

Create Field Name Conversions

Follow these steps to create Field Name Conversion records:

  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 a field name conversion should be created. The Database Assignment Card page opens.
  3. Open Field Name Conversions
    • Click Field Name Conversion in the Related action menu. The Field Name Conversions page opens.
  4. Create Field Name Conversion records
    • Enter Destination Table ID, Destination Table Name, Destination Field ID and Destination Field Name and the corresponding Source Table ID, Source Table Name, Source Field ID and Source Field Name.
    • Please note that the special characters in the field names must be replaced according to the database settings.

Export Field Name Conversions

Follow these steps to export Field Name Conversion records:

  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 a field name conversion should be exported. The Database Assignment Card page opens.
  3. Open Field Name Conversions
    • Click Field Name Conversion in the Related action menu. The TabFieldle Name Conversions page opens.
  4. Export Field Name Conversion records
    • Click Export to JSON in the action bar.
  5. Set Filter
    • Set a filter for e.g. Destination Field ID to determine which field name conversion records should be exported. If no filters are set, all field name conversion records are exported.
  6. Start Export
    • Click OK to start the export. The file SQL_FieldNameConversion.json is created and exported. You can import this file for future migration projects.

Import Field Name Conversions

Follow these steps to import Field Name Conversion records:

  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 a field name conversion should be imported. The Database Assignment Card page opens.
  3. Open Field Name Conversions
    • Click Field Name Conversion in the Related action menu. The Field Name Conversions page opens.
  4. Import Field Name Conversion records
    • Click Import from JSON in the action bar. The Import Json File page opens. Then select a JSON file for import.
  5. Set Filter
    • Set a filter in the request page for e.g. Destination Field Name to determine which field name conversion records should be imported. If no filters are set, all lines are imported.
  6. Start Import
    • Click OK to start the import. Existing records will be overwritten.

Next step

Disable Indexes