Documentation / Compare / Getting Started

Getting Started — Compare

Treat Source as the desired state and Target as the database you will update. Sync scripts always move target toward source — swap cards if you picked the wrong direction.

Getting Started

  1. Launch DBLenseCompare.exe (no installer required)
  2. Activate a license or start the free trial when prompted
  3. Connect a Source database (the desired state)
  4. Connect a Target database (the database to bring in line)
  5. Open Schema Compare or Data Compare and run Compare

Setting Up Source & Target

  1. Click Connect… on the Source card (or the instance pill)
  2. Enter server details, choose authentication, then select a database
  3. Repeat for Target
  4. Change databases anytime with the database dropdowns without reconnecting to the instance

Supported authentication: Windows, SQL Server login, Azure Entra ID (password), and Azure Entra ID (MFA). Trust Server Certificate is available for lab/dev connections.

Source and target can be on different servers, different SQL Server versions, or a mix of on-premises and Azure SQL.