Table of Contents

Set up a new connection

In this article, you will learn how to set up the SQL Migration app in Business Central and to check the connection to the database.

Prerequisites

License

  • The app must always be run with a developer license.

SQL Server

  • DB Owner permissions on the source and destination databases are required for the user. To do this, open the Properties from the user's context menu (right mouse button) in the SQL Server Management Studio in the Object Explorer under SQL Server Name Security > Logins. In the Login Properties page, in the User Mapping area, assign the user the db_owner role for the corresponding database.
  • Set up authentication mode to log on to the SQL Server with a local SQL Server user account. To do this, right-click on the name of the corresponding SQL server in the SQL Server Management Studio and then open the Properties from the context menu. Now switch to page Security in the properties of the SQL server. In the Server authentication section, select SQL Server and Windows Authentication mode. Then restart the service of the corresponding SQL server in the Services or in the SQL Server Configuration Manager.
  • Enable the Named Pipes and TCP/IP protocols in SQL Server Configuration Manager. To do this, open the SQL Server Configuration Manager and select the protocols for the corresponding SQL Server in the SQL Server Network Configuration area. Then you enable the Named Pipes and TCP/IP protocols. Then restart the service of the corresponding SQL server in the Services or in the SQL Server Configuration Manager .

Role center

The Aident SQL Migration app offers a dedicated profile (Aident SQL Migration) that enables you to manage all aspects of the migration between source and destination databases in Business Central.

SQL Migration Setup

Follow these steps to configure the Aident SQL Migration app:

  1. Navigate to SQL Migration Setup
    • In Business Central, search for and go to the SQL Migration Setup page.
  2. Configure Current Database
    • Enter the Current Database Server Name (including the instance, if any) and Current Database Name in the General FastTab.
  3. 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 confirm a 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.
    • Choose if you want to Trust Server Certificate.
    • Configure the SQL Connection Timeout (in s) to specify after how many seconds the connection to the database should be terminated.
  4. Configure Default Assignments
    • Set up which field assignment type should be set for the individual field assignment lines if field names match or if source or destination fields do not exist in the Default Assignments FastTab.
  5. Check Connection
    • Click Check Connection in the action bar to check whether a connection to the specified database can be established taking into account the existing settings.

Add another SQL user

Follow these steps to add another SQL user:

  1. Navigate to SQL Migration Setup
    • In Business Central, search for and go to the SQL Migration Setup page.
  2. Configure SQL Login
    • Set the SQL Login Type to User-Password in the SQL Login FastTab.
  3. Enter SQL user name
    • Enter the SQL user name. Make sure that the authentication type on the SQL server is set up for mixed login and that the user has the necessary permissions.
  4. Enter password
    • Enter and confirm the password.

Update password for an SQL user

Follow these steps to update the password of an SQL user:

  1. Navigate to SQL Migration Setup
    • In Business Central, search for and go to the SQL Migration Setup page.
  2. Configure SQL Login
    • Set the SQL Login Type to User-Password in the SQL Login FastTab.
  3. Set password
    • Click Set password in the action bar.
  4. Enter password
    • Enter and confirm the password.

Next step

Add databases