Sobre o Source Control for Oracle

Controle fácil de fonte de banco de dados com SVN e TFS.

Source Control for Oracle is a Windows application that makes it easy to version-control your schemas with 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. Easily connect Oracle schemas to your existing source control system and make tracking and sharing schema changes simple.

Source Control for Oracle makes 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
  • NEW! 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

Easy Oracle Version Control
Source Control for Oracle is a Windows application that makes it easy to version-control your schemas with 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.

Share Changes with One Click
Source Control for Oracle checks your changes into version control for you, so you don't have to rely on manual scripting and source-controlling processes. You can compare changes to source control and see highlighted differences. When you're ready, just type a message and click Check in.

Record Every Database Check-In
The History tab shows every change, so you can easily track which objects were changed, who checked them in, and when. Each object can be compared before and after check-in with the differences viewer; if something went wrong with your latest change, the difference viewer makes it easy to spot and fix.

Works Alongside your IDE
Source Control for Oracle works independently of your editor, so whether you use SQL Developer or PL/SQL Developer, you don't have to change how you work on your database. Minimized, the tool keeps the team up-to-date through task bar notifications while you work.

Lock Objects
If your team works on a shared development database, you can lock objects while you work on them. If someone tries to edit an object, the server will return an error message. Comments can be added when locking objects to aid communication across the team.

Enables Sandboxed Development
Source Control for Oracle makes setting up sandboxed environments easy. Developers can get the latest version from source control before starting work to make sure they're not overwriting other people's changes. When a new person joins the team, it's simple to get them up and running with a fresh copy of the database in source control.

Benefits of Database Source Control

Source-controlling Oracle databases
Source control (also known as version control or revision control) is the management of changes to a file or set of files. Source control systems do many useful things:

  • You can see a history of every change made to a file: what was changed, who changed it, and why
  • You can easily revert to earlier versions of a file, so mistakes can easily be undone, and there's no risk in experimenting
  • Teams can work on a single file without blocking each other or overwriting their changes
  • Teams can work from a single, shared repository of files, without having to constantly send files back and forth – everyone works from the same page

Benefits of source-controlling databases

Change management
Normally, workarounds are needed to make sure developers have the latest database changes. That means discussing updates in person or email, and pausing development until everyone's up to date. Some development teams share work with backups and restores, or a custom in-house solution; these are usually time-consuming and subject to human error.

With source control, your team can quickly get the latest changes and commit their own. It's easy to track who changed what, when they did it, and why. If conflicts occur, you can compare the differences before committing a change.

Prevent and contain disasters
Without source control, it's easy for a database change to accidentally lead to an overwritten table, data loss or a bug, even in projects with single developers modifying a simple database. Again, the problem is amplified in teams.

Source control systems reduce the likelihood of disasters by increasing the transparency of the development process and helping you catch bugs early. If problems do occur, mistakes can be easily undone by reverting to a previous version.

Resuming partially completed work
Normally, resuming partially completed work can be slow; developers have to spend time understanding each other's code and the state of the work. For large or distributed development teams, this problem is amplified.

By allowing developers to easily document their changes in a source control system, teams can easily review the history of a project, getting up and running much more quickly.

Many organizations are required to comply with regulatory standards, including the Sarbanes–Oxley Act and the Statement on Auditing Standards No. 70: Service Organizations (SAS70) (both US). Databases contain critical data, so compliance auditors usually require organizations to account for every change to a database.

By source-controlling databases, it's easy to:

  • manage how schema and data changes are made
  • document schema changes
  • maintain a detailed history of who made which changes
  • document database schema and access permissions
  • revert to previous versions if problems occur

Source control tools for Oracle
Red Gate's dedicated source control tool for Oracle databases, Source Control for Oracle, connects your database directly to your SVN or TFS source control system. By automatically storing a complete history of your Oracle database schema changes, Source Control for Oracle makes implementing source control easy.