Version control tools

List of source version control tools for databases.
State-based tools - generate the scripts for database upgrade by comparing database structure to the model (etalon).
Migration-based tools - help/assist creation of migration scripts for moving database from one version to next.

Visual Studio Database Project

Visual Studio supports SQL Server Data Tools (SSDT) that includes a Schema Compare utility that you can use to compare two database definitions. The source and target of the comparison can be any combination of connected database or SQL Server database project. The comparison results appear as a set of actions that must be taken with the target to make it the same as the source. Once the comparison is complete you can update the target directly or generate an update script that has the same effect.

Generate change script: Yes
Runs on: (for desktop): Mac OS,Windows
Type: State-based tools
Repositories: File
Commercial: Commercial
Free edition: Yes

Redgate SQL Source Control

Redgate SQL Source Control enables version control schemas and reference data, roll back changes, and maintain the referential integrity of your database. You can manage pre & post deployment scripts within SQL Source Control to automate SQL changes when deploying.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: State-based tools
Repositories: Database
Commercial: Commercial
Free edition: No

dbForge Source Control

dbForge Source Control is a convenient SSMS add-in for SQL Server database change management in popular version control systems, including Git (including GitHub), TFS, SVN, Mercurial. The tool allows version-controlling database schemas and reference data, roll back changes, and maintain the referential integrity of your SQL databases.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: State-based tools
Repositories: File
Commercial: Commercial
Free edition: No

ApexSQL Source Control

ApexSQL Source Control is a Microsoft SQL Server Management Studio add-in, which integrates source control with SQL Server database development. It allows to source control SQL databases and objects directly from inside SSMS. The tool quickly setup source control connections and filter objects that will be version controlled.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: Migration-based tools
Repositories: Database
Commercial: Commercial
Free edition: No

Datical

Datical is database management software that automates the deployment of database schema updates. It allows to simulate the impact of database changes before they are applied. This can help prevent errors and outages, so you can confidently deploy faster with database continuous integration.

Generate change script: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Type: State-based tools
Repositories: Database
Commercial: Commercial
Free edition: No

DB Ghost Change Manager

DB Ghost Change Manager includes tools that allow you to script out your databases into individual DROP/CREATE scripts, place those scripts under source control, modify them there and then build and deploy from those scripts. Once a database has been successfully scripted and placed under source control it can then be regarded as the "source database".

Generate change script: Yes
Runs on: (for desktop): Windows
Type: State-based tools
Repositories: Database
Commercial: Commercial
Free edition: No

Version SQL

VersionSQL is the straightforward SQL Server version control add-in. It's made to do one thing and do it well: Commit SQL to Git and Subversion source control repositories. It enables hassle-free change tracking for stored procedures, views, table schema, etc. by checking them into your source control repository.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: State-based tools
Repositories: Database
Commercial: Commercial
Free edition: Yes

Liquibase

Liquibase is an open-source database-independent library for tracking, managing and applying database schema changes. It has the ability to roll changes back and forward from a specific point. It makes it easy to define database changes in a format that’s familiar and comfortable to each user and then automatically generates database-specific SQL for you.

Generate change script: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Type: Migration-based tools
Repositories: File
Commercial: Free
Free edition: Yes

Flyway

Flyway provides version control for your database so you can migrate it with ease and confidence. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, ...) is supported) or Java (for advanced data transformations or dealing with LOBs).

Generate change script: No
Runs on: (for desktop): Linux,Mac OS,Windows
Type: Migration-based tools
Repositories: File
Commercial: Commercial
Free edition: Yes

FluentMigrator

FluentMigrator is a migration framework for .NET. Database schema changes are described in classes written in C# that can be checked into a version control system.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: Migration-based tools
Repositories: File
Commercial: Free
Free edition: Yes

Ruby on Rails Migrations

Ruby on Rails Migrations enables to use Ruby for defining database schema changes, which makes it convenient to use a version control system for maintaining synchronization with the actual code.

Generate change script: Yes
Runs on: (for desktop): Linux,Mac OS,Windows
Type: Migration-based tools
Repositories: Database
Commercial: Free
Free edition: Yes

Idera DB Change Manager

DB Change Manager puts the power of change tracking, schema comparison, software-generated synchronization scripts, and flexible reporting into the hands of DBAs and developers. It captures and compares schema differences between one or more archived or live databases, handles object dependencies and preserves data. It also generates alter scripts to sync selected objects or restore to a prior state.

Generate change script: Yes
Runs on: (for desktop): Windows
Type: State-based tools
Repositories: Database
Commercial: Commercial
Free edition: No

yuniql

yuniql is an open source schema versioning and migration tool made with .NET Core. Deploy fresh databases fast using plain-SQL, seed lookup tables and test data from CSV and run environment-specific migrations. yuniql is released as stand-alone .exe app (no CLR needed!), Azure DevOps Pipelines Tasks, .NET Core tool, nuget package and Docker container.

Generate change script: -
Runs on: (for desktop): Linux,Windows
Type: Migration-based tools
Repositories:
Commercial: Free
Free edition: Yes