1. DB Best Documentation
  2. Connecting to a Microsoft SQL Server database

Connecting to a Microsoft SQL Server database

In DB Best Migration Platform, you can connect to a Microsoft SQL Server database as a source database and as a target database (both for migration and upgrade projects). Use the following procedure to connect to your Microsoft SQL Server database.

  1. Press Ctrl+N or click the New button to create a new project.
  2. Select Microsoft SQL Server in the Source Platform or Target Platform drop-down list.
    DB Best Migration Platform connecting to SQL Server new project
  3. Select the Standard option in the Connection mode drop-down list if you want to connect to the Microsoft SQL Server database in the standard mode.DB Best Migration Platform connecting to SQL Server standard mode
    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been already used).
    • Provide the rest of connection information to the Microsoft SQL Server database: Server Port, Authentication method, Database name, and User name. You can manually enter these values manually or select them from drop-down lists (Authentication method can only be chosen between SQL Server Authentication and Windows Authentication from the drop-down list).
    • Enter Password to complete the information about Microsoft SQL Server database connection.
    • Check the Use SSL option to establish a secure connection to the Microsoft SQL Server database.
    • Check the Trust server certificate option to specify that the driver can trust the server certificate when connecting to the Microsoft SQL Server database using TLS.
      Please note, that if the encrypt property is set to true and the trustServerCertificate property is set to true, the Microsoft JDBC Driver for SQL Server will not validate the SQL Server SSL certificate.
    • Press the Connect button to establish the connection to your Microsoft SQL Server database. If the connection credentials you specified are wrong, the application will display the error message.
  4. Select the Connection String option in the Connection mode drop-down list if you would like to connect to the Microsoft SQL Server database using a special connection string.DB Best Migration Platform connecting to SQL Server connection string mode
    • Enter the Connection string manually or edit the proposed one.
    • Press the Connect button to establish the connection to your Microsoft SQL Server database. If the connection credentials you specified are wrong, the application will display the error message.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].