Fork me on GitHub

Obevo: Evolve Your Database Objects

Deploying tables for a new greenfield application?

Or looking to improve your database change management for a years-old system with hundreds or thousands of tables, views, stored procedures, and more?

Obevo has your database deployment use case covered.

Quickstart Examples

Why Use Obevo for Database Deployment?

Organized maintenance of all your DB object files to handle all use cases

By allowing your DB files to be maintained per object (as you would with classes in application code), DB file maintenance becomes much easier compared to other tools that require a new file or change definition per migration:

  • Changes for a particular table can be reviewed in one place
  • Stateless objects like stored procedures and views can be edited in place without specifying any new incremental change files
  • All of this is possible without having to define the complete order of your file deployments; Obevo figures it out for you

Click here for more information on how Obevo works and how its algorithm compares to what most other DB Deployment tools do

1 file per object structure

In-memory and integration testing

How do you test your DDLs before deploying to production?

Obevo provides utilities and build plugins to clean and rebuild your databases so that you can integrate that step into your integration testing lifecycle.

Obevo can take that a step further by converting your DB table and view code into an in-memory database compatible format that you can use in your tests. The conversion is done at runtime, so you do not have to maintain separate DDLs just for in-memory testing

Easy onboarding of existing systems

Hesitant about getting your existing database schema under SDLC control due to how objects your application has built up over the years? Obevo has been vetted against many such cases from applications in large enterprises.

Versatile to run

Obevo can be invoked via:

Obevo is designed to allow your DB code to be packaged and deployed alongside your application binaries.

Treat your DB code like you would treat your application code!

DBMS-specific features

Obevo currently supports DB2, MS SQL Server, Oracle, PostgreSQL, Amazon Redshift, Sybase ASE, Sybase IQ, HSQLDB, H2, and MongoDB.

It includes DBMS-specific handling, such as DB2 reorgs and handling transaction log checks for Sybase ASE.

Document Conventions

This documentation assumes we are running this from a Windows desktop, unless otherwise specified.

Adjust the command line arguments accordingly for Linux if you choose.