Configuration Management tools for Oracle/SQL database definitions?

Configuration Management tools for Oracle/SQL database definitions?

Post by Nels P. Olse » Tue, 21 Jan 1997 04:00:00



We are a software vendor of a large, integrated application suite.
The (Oracle) database definition evolves rapidly, and is currently
nearing 1000 tables.  Several years ago we wrote our own upgrade
utility, but it does not handle Oracle 7 features (triggers,
stored procedures, integrity constraints).  It also deals poorly
with LONG datatypes.

To complicate matters, we keep the current database definition
in a database itself.  Our in-house upgrade utilities compare
an existing database definition to the abtract definition in our
"database definition database", and generate appropriate SQL DDL
statements to reconcile that existing database's structure to
the "official release" definition.

We'd rather use a 3rd party solution rather than enhance our
home-brew tools.  Do commercial tools like this exist?
Has anyone else attempted to create utilities to upgrade
SQL database definitions from one arbitrary configuration to
another?
--
Nels P. Olsen
Senior Software Engineer
Penta Technologies, Inc.

 
 
 

1. DC-Washington-249698--Configuration Management-PVCS-ORACLE-MS ACCESS-Configuration Management Specialist-Intermediate

******** VISIT US AT http://www.selectjobs.com ***********
=
*************************************************************
Company    : CareerMagic
Website    : http://www.careermagic.com
Job Title  : Configuration Management  Specialist-Intermediate
Location   : Washington, DC
Job Type   : Full-Time Salaried
============================

Member of the Technical Support Team which is responsible for CM Tools and
Application Release Management. Primary Responsibility wil be to support PVCS
Tracker and Version Manager administration and enhancement. Specific
responsibilities will include such activities as training users, documenting
processes, reviewing proposed tools changes, evaluating new tools, etc. Will
also assist other team activities as required.</p>

<strong>Education:</strong>B.S. degree or equivalent experience</p>

<ul><li>5-10 years CM experience; strong software skills, experience with
automated CM tools(change and baseline management) and familiarity with ORACLE;
excellent analytical skills,ability to write, listen and communicate
effectively, strong desire to work with a team.</li><li>Applications/Systems
documentation - 2 years minimum</li></ul>

<strong>Desired Technical Skills:</strong><ul><li>PVCS Tracker, PVCS Version
Manager, Oracle and Access experience; hands on database orsoftware development
experience.</li></ul>

Travel Required          :None
Educational Requirements :Bachelors Degree
=
Required Skills
* Configuration Management
* PVCS
* ORACLE
* MS ACCESS
=
To apply to this position connect to www.CAREERMAGIC.com and confidentially
submit your resume and profile.
=
Contact Information:
Reference : _01E0JBE4B-B0118
HR

***********************  http://www.selectjobs.com  ****************************

                The On-Line, On-Target Job Finder for Computer Professionals  

** Post Your Resume and see results immediately!! ** Always free **
** Matching Resumes E-mailed daily
**  Your ads are virtually guaranteed to be seen by jobseekers on the NET **

                    ** Automatic Posting to **
   ** Yahoo            ** Americas Job Bank    ** AltaVista   *** ClassifiedsWarehouse
   ** erpcentral.com   ** Classifieds 2000     ** Usenet Newsgroups
           ** VBOnline.com   ** ORASearch.com  
               *** OVER 100 MILLION HITS/MONTH COMBINED !!! ***

***********************  http://www.selectjobs.com  ****************************

2. Help! IIS/ODBC/SQL6.5 stop connecting after a while? ASP loads okay, but no data via ADO/ODBC???

3. US-CA-Westlake ANALYST CASE Tools, Configuration Management SMCI

4. VFP 5.0 & Menu

5. Software Configuration Management tools

6. estimate table size

7. Configuration management tools for W4GL

8. US-CA-SF Bay Area-Sr. Knowledge Engineer-Recruiter

9. SQL Server databases under Configuration Management control

10. NY-NEW YORK-228026--Project Management-Database Design-CASE Tools-Management-ORA

11. GUI-based Database management tools for Oracle?

12. Database Management Tools for Oracle Parallel Server