What are some good Oracle Db maintenance Tools.

views:

102

answers:

+1 Q:

What are some good Oracle Db maintenance Tools.

We have grown from a small time of 2-3 developers to about 30 developers very quickly. We supposedly never needed Source Control, or Db Monitoring or Schema diagrams.

Now we see more and more terrible code being moved to the Production. Is there an off the shelf product for oracle that will help manage version control and deployment management from Test, to UAT, to Prod?

Also nice to have would be Schema diagrams, Documentation Tools, some amount of performance profiling capabilities. But primarily would like to a tool to manage code source control and Migration for oracle scripts, DDL, DMLs etc.

+1 A:

have you considered SVN for your source control and management of scripts, DDLs and etc? Our ORACLE DBAs use it here and they swear by it.

northpole 2009-05-27 13:32:44

We use SVN for to maintain source control, but I wanted something more in "touch" with the database. Is there a software you know of thats linked more closely to oracle. ?

Reuben 2009-05-27 15:34:36

+1 A:

I srongly recommend getting Oracle'e SQL Developer. This integrates with SubVersion, provides an overview of the entire database, including procedures, schema changes and so on. This will make your life easier.

Thomas Jones-Low 2009-05-27 14:52:47

I might try SQL developer again, a year ago, it was bloated buggy piece of software. Though it was still a beta, it seemed like it had been in Beta forever with no improvement.

Reuben 2009-05-27 15:30:03

It's getting better. I haven't used it for integrating with version control, but I have used it to extract DDL fairly easily.

Jeffrey Kemp 2009-05-28 02:51:07

The current version is 1.5.4. I have no complaints about it, it does everything I ask of it with minimal swearing. It is written in Java (everything oracle produces is Java these days) which results in some people saying no.

Thomas Jones-Low 2009-05-28 15:25:14

TOAD (by Quest Software) is fantastic and includes most of what you want including source control.

Jeff Clement 2009-05-27 15:06:02

are you talking about the Toad for Dba's ? We use Toad For Oracle, which lacks the source control, unless its an add- in or something.

Reuben 2009-05-27 15:33:01

ansaurus

tags:

views:

answers:

What are some good Oracle Db maintenance Tools.

related questions