Picture of Source Control for Oracle

Source Control for Oracle

von Red Gate

Einfache Datenbankquellkontrolle mit SVN & TFS

Source Control for Oracle

  • Vereinfacht das Verfolgen und Teilen von Schemaveränderungen
  • Veränderungen prüfen ist so einfach wie einen Knopf zu drücken
  • Speichert die komplette Geschichte von jedem geprüften Objekt
  • Vergleicht jedes Objekt in der Datenbank mit Quellkontrolle Side-by-Side
  • Es ist nicht notwendig, die Verwendung von Ihrem Lieblingseditor zu stoppen
  • NEU: Schleußen Sie Objekte in eine gemeinsame Entwicklungsdatenbank

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.

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.

Compliance

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). 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

Redgate'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.

Another Redgate tool, Schema Compare for Oracle, lets you compare and deploy changes from the files under source control, useful for spotting changes, reverting to a previous version, and deploying upgrades.

SKU Name Upg Mon. products.netprice products.grossprice
116921 SourceControlforOracle 10 Benutzer, Neue Lizenz inkl. 12 Monate Support 12 €2600.00 €3094.00
116922 Source Control for Oracle, 10 User Pack, eng., Win, Verlängerung inkl. 1 Jahr Maintenance 12 €520.17 €619.00
116923 SourceControlforOracle 10 Benutzer, Neue Lizenz inkl. 24 Monate Support 12 €3120.17 €3713.00
116924 Source Control for Oracle, 10 User Pack, eng., Win, Verlängerung inkl. 2 Jahre Maintenance 24 €1040.34 €1238.00
116925 SourceControlforOracle 10 Benutzer, Neue Lizenz inkl. 36 Monate Support 12 €3640.34 €4332.00
116926 Source Control for Oracle, 10 User Pack, eng., Win, Verlängerung inkl. 3 Jahre Maintenance 36 €1559.66 €1856.00
116927 SourceControlforOracle 5 Benutzer, Neue Lizenz inkl. 12 Monate Support 12 €1379.83 €1642.00
116928 Source Control for Oracle, 5 User Pack, eng., Win, Verlängerung inkl. 1 Jahr Maintenance 12 €274.79 €327.00
116929 SourceControlforOracle 5 Benutzer, Neue Lizenz inkl. 24 Monate Support 12 €1654.62 €1969.00
116930 Source Control for Oracle, 5 User Pack, eng., Win, Verlängerung inkl. 2 Jahre Maintenance 24 €550.42 €655.00
116931 SourceControlforOracle 5 Benutzer, Neue Lizenz inkl. 36 Monate Support 12 €1930.25 €2297.00
116932 Source Control for Oracle, 5 User Pack, eng., Win, Verlängerung inkl. 3 Jahre Maintenance 36 €825.21 €982.00
152407 Source Control for Oracle, 1 User, Lizenz inkl. 1 Jahr Maintenance eng. Win. User Pack 12 €325.21 €387.00
154027 Source Control for Oracle, 1 User, 1 Jahr Maintenance Verlängerung eng. Win. User Pack 12 €65.00 €77.35