Microsoft SQL Server support: see which tables, indexes, views, procedures and functions differ between environments, rehearse every change inside a transaction that is rolled back, then apply it in one transaction.
From $10.95 monthly or $99 yearly Per seat, one device each
PostgreSQL / inspect a difference before applying it.
dbmigrate reads the live Microsoft SQL Server catalog, orders every change by its dependencies, and rehearses the whole plan before you decide.
The full plan runs on the target inside a transaction that is rolled back. You see which statement would fail before anything changes. Then it is applied in one transaction.
dbmigrateBEGIN TRANSACTION;ROLLBACK; -- Dry run: nothing is keptDefault constraints, schema-bound views, indexes and foreign keys are dropped and recreated in dependency order. dbmigrate never uses CASCADE.
dbo.vOrderTotalsdbo.Orders.Amountdbo.vOrderTotalsConnect with a SQL login, Microsoft Entra ID (password or service principal) or Windows sign-in. Secrets are encrypted on your computer and never sent anywhere else.
encrypt: strict · mandatory · optionalsign-in: SQL login · Entra ID · WindowsSources are read inside a transaction that is always rolled back. If the source login can write, dbmigrate tells you on screen, and blocks it on high-protection connections.
dbmigrate supports Microsoft SQL Server 2017, 2019 and 2022, on premises, in virtual machines or in Docker, as well as Azure SQL Database and Azure SQL Managed Instance.
With a SQL login (user name and password), with Microsoft Entra ID (password or service principal), or with Windows sign-in using a domain user and password. Passwords and secrets are stored encrypted on your computer and never leave it.
Microsoft SQL Server can roll back most schema changes. dbmigrate runs the whole plan on the target inside a transaction and then rolls it back, so you see exactly which statement would fail without changing anything. No shadow database is needed. The few statements that cannot run in a transaction are labelled in the plan before you apply.
Microsoft SQL Server cannot lock a session to read-only. dbmigrate reads a source database inside a transaction that is always rolled back, checks whether the login can write and warns you if it can, and blocks unsafe filter text. The app tells you on screen whenever one of these safeguards applies. For full protection, use a login that can only read.
No. dbmigrate for Microsoft SQL Server is a separate product. Each license works in the product it was bought for. Licenses are per seat, and each seat activates on one device.
$199 USD per year per seat. See Microsoft SQL Server pricing
macOS (Apple Silicon & Intel) / Windows x64