RE: Schema objects version control

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_at_post.queensu.ca] Sent: Wednesday, November 02, 2005 8:56 AM To: Reidy, Ron; 'Oracle-L_at_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_at_arraybiopharma.com] Sent: November 2, 2005 10:43 AM
To: poelsb_at_post.queensu.ca; Oracle-L_at_Freelists. Org Subject: RE: Schema objects version control

We use CVS for our repository.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ben Poels Sent: Wednesday, November 02, 2005 7:54 AM To: Oracle-L_at_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

--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 02 2005 - 10:14:13 CST