Version control tools for Oracle
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.
Source Control for Oracle
Source Control for Oracle provides a convenient platform for version-control your schemas and static data with Git, SVN, and TFS. You can continue making changes in your IDE without the need to work on separate script files, so there's no disruption to the way you work.
Generate change script: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | State-based tools |
Repositories: | Database |
Commercial: | Commercial |
Free edition: |
DBmaestro Source Control
DBmaestro Source Control manages and documents all changes made to database code, structure, and content across all teams. The Version Control Module validates database changes against schemas and relevant content while preventing unauthorized and out-of-process changes.
Generate change script: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | State-based tools |
Repositories: | Database |
Commercial: | Commercial |
Free edition: |
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: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | - |
Repositories: | - |
Commercial: | Free |
Free edition: |
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: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | Migration-based tools |
Repositories: | File |
Commercial: | Commercial |
Free edition: |
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: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | Migration-based tools |
Repositories: | File |
Commercial: | Free |
Free edition: |
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: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | Migration-based tools |
Repositories: | Database |
Commercial: | Free |
Free edition: |
DBGeni
DBGeni helps to manage database migrations that include applying and rolling them back to move your database from version to version easily. If you follow a few opinionated rules, DBGeni knows where to find your migrations scripts, the order to run them and what still needs to be applied.
Generate change script: | |
---|---|
Runs on: (for desktop): | Linux,Windows |
Type: | Migration-based tools |
Repositories: | Database |
Commercial: | Free |
Free edition: |
Sqitch
Sqitch is a database change management application. Changes are implemented as scripts native to your selected database engine. It manages changes and dependencies via a plan file and employs a Merkle tree pattern similar to Git and Blockchain to ensure deployment integrity.
Generate change script: | |
---|---|
Runs on: (for desktop): | Linux,Mac OS,Windows |
Type: | - |
Repositories: | Database |
Commercial: | Free |
Free edition: |
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: | |
---|---|
Runs on: (for desktop): | Windows |
Type: | State-based tools |
Repositories: | Database |
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: |