Bild von Deployment Suite for Oracle

Deployment Suite for Oracle

von Red Gate

Weniger Fehler, bessere Transparenz, blitzschnelle Entwicklung

Deployment Suite for Oracle

Vergleicht Schemas und Daten - schnelle und klare Erfassung von Differenzen in Schemaobjekten und Tabellendaten über Instanzen Ihrer Datenbank:

  • Vergleicht vielfältige Schemas und Tabellen gleichzeitig
  • Erkennt Differenzen in den DDL für Schemaobjekte
  • Eine grafische Ansicht von Reihen- und Spaltenhighlight
  • Filtert Vergleichsresultate und generiert interaktive Berichte

Beinhaltet:

  • Source Control for Oracle
  • Schema Compare for Oracle
  • Data Compare for Oracle

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.

Set up accurate deployments for schema changes

Generate update scripts without writing a single line of PL/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 your deployments with the command line

Easy source control for Oracle database code

Take the complexity out of recording schema changes in Git, Subversion or Team Foundation Server.

  • 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
  • Get notifications about 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

Automate tasks with the command line interface

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 (you'll also need the SQL Automation Pack).

Continuous integration

Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system.

Code changes are checked into source control, triggering an automated build with unit tests and early feedback in the form of errors returned. A stable current build is consistently available, and if a build fails, it can be fixed rapidly and re-tested.

If you want to get started with continuous integration for your database, you'll need the SQL Automation Pack.

Introduction

Introduction to database continuous integration

A CI server uses a build script to execute a series of commands that build an application. Generally, these commands clean directories, run a compiler on source code, and execute unit tests. However, for applications that rely on a database back-end, build scripts can be extended to perform additional tasks such as creating and updating a database.

The diagram illustrates a typical integration process. The automated continuous integration process begins each time the server detects a change committed to source control by the development team.

Continuous integration ensures that if at any stage a process fails, the ‘build' is deemed broken and developers are alerted immediately.

Database code

Database code is code, and should therefore be treated in the same way as your application code. However, the principal difficulty underlying continuous integration for databases is the lack of a simple way to keep a database in source control and deploy it to a target server.

The database is unlike application code in as much as it contains a state that needs to be preserved after an upgrade. Where a production database already exists, DML and DDL queries modify the state of a database. Unlike application code, there is no source code to compile. Deployment therefore relies on creating upgrade scripts.

The lack of database source code makes it difficult to maintain a current, stable version in source control. Creation scripts can be checked into the source control repository, but despite their importance, the disciplined creation and on-going maintenance of these scripts is not often considered a core part of the database lifecycle.

Where changes are deployed to an existing database, all differences and dependencies must be accounted for. In some production deployments, this involves multiple targets with different schemas and data. The manual process is time consuming, prone to errors, and one that should not be left unresolved at the end of the project cycle.

Benefits of database CI

Keeps your database up to date

Databases may figure in your CI process because the application code requires a database to function correctly. The database schema version corresponds to an analogous application code version. Any changes to the application code or the database structure could, in theory, break the system. Consequently, they should trigger the CI process.

Once a database is maintained in source control, Redgate tools can build a clean database from its source files to accompany the application build.

If you already have internal test databases that need to match the development databases, you can keep them up to date with the latest version, using continuous integration.

Verifying database deployment scripts

Developers get immediate feedback on each change they commit to the database scripts. If the build fails, they know exactly which change caused it to fail.

Artikelnummer Bezeichnung Upg Mon. Nettopreis Bruttopreis
152047 Deployment Suite for Oracle, 1 User, Lizenz inkl. 1 Jahr Maintenance eng. Win. User Pack 12 €1453,78 €1730,00
153757 Deployment Suite for Oracle, 1 User, 1 Jahr Maintenance Verlängerung eng. Win. User Pack 12 €289,92 €345,00
116843 Deployment Suite for Oracle, 10 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €11594,96 €13798,00
116844 Deployment Suite for Oracle, 10 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €2297,48 €2734,00
116845 Deployment Suite for Oracle, 10 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €13891,60 €16531,00
116846 Deployment Suite for Oracle, 10 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €4594,96 €5468,00
116847 Deployment Suite for Oracle, 10 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €16189,92 €19266,00
116848 Deployment Suite for Oracle, 10 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €6892,44 €8202,00
116849 Deployment Suite for Oracle, 5 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €6156,30 €7326,00
116850 Deployment Suite for Oracle, 5 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €1220,17 €1452,00
116851 Deployment Suite for Oracle, 5 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €7376,47 €8778,00
116852 Deployment Suite for Oracle, 5 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €2441,18 €2905,00
116853 Deployment Suite for Oracle, 5 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €8597,48 €10231,00
116854 Deployment Suite for Oracle, 5 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €3664,71 €4361,00