Database Change Management
Blue Turtle implements the tools that can provide the benefits of continuous delivery to your Oracle database: safe releases, efficient development and fast feedback.
The Deployment Suite for Oracle gives you all the tools you need to speed up deployment and eliminate errors at every stage of your database development.
Deployment Suite for Oracle tools include:
Source Control for Oracle
Take the complexity out of recording schema changes in your existing source control system.
Schema Compare for Oracle
Compare and synchronise schemas. Deploy changes from source control, and automate for continuous integration.
Data Compare for Oracle
Compare table data fast and generate update scripts without writing a single line of SQL.
Take the complexity out of recording schema changes in your existing source control system:
- Checking in changes is as simple as writing a log message and clicking a button.
- Use the difference viewer to inspect every change before you check it in.
- Notifications highlight new changes.
- See who modified the database and why, and access a history of every change.
- Compare your database to past revisions in source control.
Compare schemas and data fast.
Quickly and clearly see differences in schema objects and table data across instances of your database:
- Compare multiple schemas and tables at once.
- See differences in the DDL for schema objects.
- A graphical view of rows and columns highlights where data is out of sync.
- Filter comparison results and generate interactive reports.
- Deploy database changes accurately.
Generate update scripts without writing a single line of SQL:
- Synchronize environments using the software or save deployment scripts to review and execute in your IDE.
- Group objects or select individual changes.
- Get deployment notifications about dependencies, truncations, and other issues.
- Deploy changes from any version in source control.
- Automate tasks with the CLI
Access the functionality of Schema Compare and Data Compare through the command line:
- Automate scheduled tasks like comparisons and deployments.
- Include in your build system for continuous integration.
Make tracking and sharing schema changes simple.
- Checking in changes is as simple as writing a log message and clicking a button
- Store a complete history of every object checked in
- Compare each object in the database with source control side-by-side
- No need to stop using your favorite editor
- Lock objects on a shared development database
- Enable easy setup of sandboxed environments
- Remove the need for complex solutions to script out database objects and check them into source control
Database diff tool for Oracle schemas.
- Identify differences between your largest environments within minutes — smaller schemas take seconds to compare
- Eliminate mistakes migrating database changes from dev, to test, to production
- Compare multiple schemas
- Compare schema objects with creation scripts — use in conjunction with Source Control for Oracle
- Deploy databases from source control
- Command line automation
- Run Schema Compare for Oracle on your build server for continuous integration (with the SQL Automation Pack)
Database diff tool for Oracle table data.
- Save time comparing and synchronising data
- Copy lookup data from development databases to staging or production
- Troubleshoot and resolve errors caused by differences in data
- Generate SQL scripts to update one database with the contents of another
- Command line automation
- Run Data Compare for Oracle on your build server for continuous integration (with the SQL Automation Pack)
Red-Gate Product Overview