Re: database source control? dbmaestro, Red Gate, Datical

From: George Leonard - Business Connexion <George.Leonard_at_bcx.co.za>
Date: Mon, 21 Jul 2014 04:44:39 +0000
Message-ID: <2DD22EF5-0A87-46A5-A60B-F12C0A933F6E_at_bcx.co.za>



Hi Kyle

There are loads of external developer type of code repository/source control apps out there, pick one that works for you.

What I ended doing to really control whats on the server, in production and what WAS there I ended writing a trigger that made a copy of the source on the server before it got replace/updated/changed.

In other words as someone installed a new package I made a copy of the old one, stored who did the change, from which machine, time etc, just in case.

Worked on packages, procedures, basically any object.

(let me know if you want, free to hack and modify as your needs require).

Yours Sincerely



George Leonard
Oracle Engineered System Specialist

Mobile: +27.82 655 2466
eMail: george.leonard_at_bcx.co.za<mailto:george.leonard_at_oracle.com> Web: http://www.bcx.com<mailto:george.leonard_at_oracle.com>

[cid:6EA60917-E50D-422D-BF1F-E8C59EADC861]

On 18 Jul 2014, at 9:04 PM, kyle Hailey <kylelf_at_gmail.com<mailto:kylelf_at_gmail.com>> wrote:

Is anyone using DBmaestro, Red Gate Source Control for Oracle or Datical to manage database source control such as schema, pl/sql, metadata source control?

Experiences, thoughts?

Thanks
Kyle



--
http://www.freelists.org/webpage/oracle-l


image003.gif
Received on Mon Jul 21 2014 - 06:44:39 CEST

Original text of this message