RE: Schema objects version control
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: "Ben Poels" <poelsb@xxxxxxxxxxxxxxx>, "Oracle-L@Freelists. Org" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Nov 2005 09:12:04 -0700
Ben,
We do not generate diff SQL - we do not use a designer type tool. Most
of our apps are 3rd party and they provide the SQL. For our in house
apps, the developers provide the SQL to me to run through test -> qa ->
prod.
The point is, we have this repository as a history of the changes to the
databases.
rr
-----Original Message-----
From: Ben Poels [mailto:poelsb@xxxxxxxxxxxxxxx]
Sent: Wednesday, November 02, 2005 8:56 AM
To: Reidy, Ron; 'Oracle-L@Freelists. Org'
Subject: RE: Schema objects version control
Hi Ron,
But CVS cannot generate the database schema changes for you. Right now
we make schema changes in Designer and generate the diff sql and apply
it. How do you implement schema changes with CVS?
Ben Poels
Queen's University
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@xxxxxxxxxxxxxxxxxx]
Sent: November 2, 2005 10:43 AM
To: poelsb@xxxxxxxxxxxxxxx; Oracle-L@Freelists. Org
Subject: RE: Schema objects version control
We use CVS for our repository.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ben Poels
Sent: Wednesday, November 02, 2005 7:54 AM
To: Oracle-L@Freelists. Org
Subject: Schema objects version control
Hi
Just wanted to canvas the list to see what people are using for version
control of their database schema objects. We have been using
SCM/Designer for schema objects and CVS for applications.
I have become increasingly frustrated with Designer and would like to
use something else. I see that TOAD for Oracle has an interface to CVS,
as well as other versioning software. I may play around with that as we
already have both of those products in house.
Any other suggestions?
Thanks,
Ben Poels
Queen's University
--
//www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended
to be for the use of the individual or entity named above. If you are
not the
intended recipient, please be aware that any disclosure, copying,
distribution
or use of the contents of this information is prohibited. Please notify
the sender of the delivery error by replying to this message, or notify
us by telephone (877-633-2436, ext. 0), and then delete it from your
system.
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
