SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Version control tools
List of source version control tools .
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.
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: |
|
DB Version Control
SSMS plugin to version control SQL Server database - tracks database changes and generates migrations for both schema objects and static data. Scripts schema objects and static data into individual files for change tracking. To be used with any version control system (GIT, TFS, SVN, etc.)
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | - |
| Type: | - |
| Repositories: | - |
| Commercial: | Commercial |
| Free edition: |
|
Apricot DB
Git based project/snapshot synchronization
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | - |
| Commercial: | Free |
| Free edition: |
|
Schema Compare for Oracle
xSQL Software's Schema Compare for Oracle can be effectively utilized to implement version control functionality, allowing you to automate the process of taking schema snapshots based on a schedule or manually, comparign snapshots to each other or to live databases, generating change scripts to either push new changes or reverse changes, and executing those scripts on the target.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | - |
| Commercial: | Commercial |
| Free edition: |
|
GenMyModel
GenMyModel supports Versioning & Time Machine. Need to go back in time? Save major and minor versions of your models. Select which one to deliver. Track change history, take snapshots, reuse, merge and rebuild models.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | - |
| Type: | - |
| Repositories: | - |
| Commercial: | Commercial |
| Free edition: |
|
dbForge Studio for MySQL
dbForge Studio for MySQL is a powerful multifunctional tool that facilitates interaction with databases. In particular, it provides the Database Projects functionality that allows for great improvement of the database development and SQL editing. Scripts and query files are logically organized and can be easily accessed.
| Generate change script: | - |
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|
dbForge Data Compare for MySQL
dbForge Data Compare for MySQL is an extremely helpful tool that allows for MySQL and MariaDB data comparison and synchronization. It provides numerous opportunities for quick analyzing the results of comparison, making alterations, and generating sync scripts. The command-line interface makes it easy to plan and automate any synchronization tasks.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|
dbForge Schema Compare for MySQL
dbForge Schema Compare for MySQL is a helpful tool for MySQL database structure comparison. It simplifies tracing distinctions in MySQL database schemas and script folders in the user-friendly interface.
| Generate change script: |
|
|---|---|
| Runs on: (for desktop): | Windows |
| Type: | State-based tools |
| Repositories: | Database |
| Commercial: | Commercial |
| Free edition: |
|