Table of Contents

Set up a new database

In this article, you will learn how to add a new database in the Aident SQL Migration app in Business Central.

Add a new database

Follow these steps to add a new database:

  1. Navigate to Database Properties
    • In Business Central, search for and go to the Database Properties page.
  2. Create New Record
    • Click New to create a new record.
  3. Configure Database
    • Specify a Code for the new database in the Settings FastTab.
    • Enter the Server Name (including the instance, if any). You may need to enter the IP address of the database server here.
    • Enter the Database Name.
    • Check Multitenant if the database is a multitenant database. Then enter the Application Database Name.
  4. Configure SQL Login
    • Choose the SQL Login Type to log in to the current SQL database server in the SQL Login FastTab. You can choose whether you want to log in with a Windows account or with a local SQL user. If you use a local SQL user, you must enter a user name and password for the user. Also make sure that the authentication type on the SQL server is set up for mixed login and that the user has the necessary permissions.
  5. Update Database Properties
    • Click Update Database Properties in the action bar. An attempt is now made to establish a connection to the specified database and read out the database properties necessary for the migration. These are displayed in the corresponding fields in the Database Properties FastTab.
  6. Select Default Company
    • Specify a Default Company of the database in the Settings FastTab, which should be used for generating individual migration queries.
  7. Update Object Properties
    • Click Update Object Properties in the action bar to fetch the necessary table and field information of the database.
  8. Check Table Properties
    • Click Table Properties in the action bar to check the fetched table data. The Table Properties page opens.
    • The Table Properties page displays all the necessary information of the database's read Business Central/NAV tables. For the sake of clarity, extension tables aren't displayed as standalone tables. The extension fields that may occur in are displayed in the Field Properties page.
  9. Check Field Properties
    • Click Field Properties in the action bar of the Table Properties page to check the fetched field data. The Field Properties page opens.
    • The Field Properties page displays all fields and their properties of a table and the corresponding extension tables.
    • The field IDs aren't displayed because this information can only be determined from the corresponding system table of the current BC instance and therefore discrepancies may occur.
    • Furthermore, the field names are displayed as they're used in the SQL database. This means that special characters are replaced if necessary.
    • Primary key fields are marked with the Used for Primary Key flag.
    • Fields of an extension table are marked with the Is Extension flag. Furthermore, extension fields have a Table GUID that differs from the original table.

Next step

Add assignments