Oracle DDL/DML script, PL/SQL in Source Control

Question

I'm looking for recommendations/guidance on how best to store DDL/DML and PL/SQL script in Source Control (we're using Microsoft Visual Studio TFS) for an in-house developed SaaS application.

We have a team of up to 7 developers working on a project that is based on a fairly straight-forward Dev/Main branch model. There are dependencies (primarily execution order) between scripts.

What has worked well under similar circumstances for you?

Answer 1

We built a tool that can manage PL/SQL code (or any other object that can be created with the CREATE OR REPLACE command) in the Oracle Database. It hooks Git to the Oracle database.

You can do basic Git tasks such as commiting, resetting, branching, cloning, merging, pulling etc... and Gitora automatically updates the PL/SQL code in the database.

You can download it at www.gitora.com