Re: database source control? dbmaestro, Red Gate, Datical
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-lReceived on Mon Jul 21 2014 - 06:44:39 CEST![]()