Transformation of existing database scheme into target state
Simplified maintenance and integration into existing projects via text files
open source initiative
Oracle Adaptive Systems is free and compatible with Oracle RDBMS
WHERE USING ORCAS CAN BE HELPFUL
- Differences in size of columns in testing environment and development database
- Questions on SVN/Git version compatibility of the development database
- Index mistakes in the production database
- Less complex syntax
- Primary key errors
- Tracking changes
- Synchronized versions of development, test and productive databases
- Versioning, branching and merging of databases
- Implementing uniform database conventions
- Parallel access on the development database
- Operating agile datanases
More information can be found in our Whitepaper: Orcas - Continuous Delivery for Databases
Hier sind die wichtigsten Bereiche der Dokumentation mit kurzer Beschreibung:
- How to work with Orcas?
- Installation What to do to get Orcas working within my own project
- Examples Example projects
- ant tasks How to setup the necessary ant processes
- Table syntax What do table creation / alteration scripts look like?
- Domain extensions How to integrate project specific extensions
- Extensions How to integrate special project specific extensions?
- Functionality of Orcas How does Orcas work
Pros | Cons
- The target state is managed in simple text-based script files. Because of this, you can use all benefits of a version control system (provide versions, change log, uniform versions, merge support etc.).
- The scripts are a reference in themselves, so you don’t have to search different schemas to get the latest version of a DB package or have to set a default scheme for references.
- You don’t need any complicated or error prone DB release scripts.
- You can create as many schemas for development or testing purposes as you want without any cumbersome comparison effort.
- When using unsupported database functions, these parts have to be managed manually.
- Project associates need to know how to work with Orcas.