Connect Azure SQL

Azure SQL Database as a source or target, through an ordinary SQL Server connection.

Last updated November 4, 2026

Azure SQL Database is SQL Server in Microsoft's cloud. DBConvert connects to it as to any SQL Server; logins, permissions and the rest are in Connect SQL Server.

Connect

  1. In the Azure portal, open the server's Networking page and add a firewall rule for your computer's public IP. Without it, Azure refuses the connection.
  2. Create the database in the Azure portal. DBConvert does not create Azure databases, because each one is billed.
  3. In DBConvert, create a Microsoft SQL Server connection:
    • Host: the server name, such as myserver.database.windows.net.
    • Port: 1433.
    • Username and Password: a SQL login. Windows Authentication does not work with Azure.

    Encryption is on for any *.database.windows.net host, whether or not Encrypt connection (TLS) is ticked.

    New connection dialog: SQL Server type, an Azure host, Encrypt connection ticked, connected

  4. Click Connect and pick the database.

Convert and sync

Azure SQL works in both directions, as a source or a target, in Convert and in Sync.

Setup: MySQL music_store as the source, Azure SQL music_store as the destination

Tables and mapping: 11 tables, new in Azure SQL

Execution: 11 tables, 15,607 rows converted into Azure SQL in 25 s

Videos

DBConvert for MS SQL & MySQL, the Windows desktop application. Convert a MySQL database of 11 tables and 15,607 rows to Azure SQL Database through an ordinary SQL Server connection, in 25 seconds. Encryption is on by itself for Azure. Your time depends on hardware, network, and data. Watch on YouTube (2:00).
DBConvert for MS Access & MS SQL, the Windows desktop application. Convert an Access file of 11 tables and 15,607 rows to Azure SQL Database through an ordinary SQL Server connection, in 29 seconds. Your time depends on hardware, network, and data. Watch on YouTube (1:46).
DBConvert for Oracle & MS SQL, the Windows desktop application. Convert an Oracle schema of 11 tables and 15,607 rows to Azure SQL Database through an ordinary SQL Server connection, in 31 seconds. Your time depends on hardware, network, and data. Watch on YouTube (1:58).
DBConvert for MS SQL & PostgreSQL, the Windows desktop application. Sync an Azure SQL Database to a PostgreSQL copy: one row inserted, one updated and one deleted in Azure arrive in PostgreSQL in 8.5 seconds. Your time depends on hardware, network, and data. Watch on YouTube (1:41).

Previous

← Connect SQL Server

Next

Connect Databricks Lakebase →