Make tracking and sharing schema changes simple
- Checking in changes is as simple as writing a log message and clicking a button
- Store a complete history of every object checked in
- Compare each object in the database with source control side-by-side
- No need to stop using your favorite editor
- NEW! Lock objects on a shared development database. Learn more
- Enable easy setup of sandboxed environments
- Remove the need for complex solutions to script out database objects and check them into source control
"Source Control for Oracle is a huge time saver. I'm blown away!"
Lewis Cunningham, Database Architect, Oracle ACE Director
Lewis Cunningham, a Database Architect and Oracle ACE Director, jumped at the chance to test out Source Control for Oracle.
I think I am some what naturally leery of software that promises to solve my problems. I've seen it all over the years, and most software falls short of promises.
Source control is still one area where life can be painful. Regular source code seems to merge well with traditional configuration management and control. Database objects don't fit nearly as well. There is usually a lot of code behind any successful database source control. Either code or it's a manual, time consuming process.
When I was offered the opportunity to test some source control software, software written specifically for Oracle, I jumped at the chance. My expectations were not all that high though. I wanted to see this pain point fixed but history said it wouldn't be that easy.
Source Control for Oracle is not a replacement for your source control repository or software. I use SVN, and this plugs into that service. You can also use it with Team Foundation Server. This is basically a layer that sits on the source control system and integrates it with Oracle.
I haven't had the software for a long time, but I have been playing with it. What I did learn, just from getting the software up and running is the basics of how it works and I am blown away. Seriously. I'm not just saying that because I was asked to review it. I don't know why anyone hasn't built this before. I've seen some attempts that were total rubbish but this is just painless.
This software will be a huge time saver for me and for teams that I work with. It doesn't remove the need to version control, but it takes the tedious steps out of the picture.
Will I be using it in the future? Oh yes!
You can read the full review on Toolbox.com: 8 Steps for Source Control Perfection.
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.
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. Learn how this feature works by visiting our documentation site.