Option to automate check-ins
We would like to have an option to enable automated check-ins. Basically, this should poll the database after every "x" minutes and see if there are any pending changes and use a automated comment like -
"Changed these objects on [date/time] by [xyz] -
(Please add any more relevant data you feel would be necessary)
Ideally, we would want to check in every script as soon as it is deployed in the database. But since, for doing that you would need an extension in our IDE, automated polling would be sufficient as well. The aim is to eliminate the risk of people forgetting to check-in changes before/after making a change.
Please note that we still want the default manual check-ins. It's just for some of our schemas, we cannot lose any of the previous versions of objects that existed at some point in time.
I’m not sure how generally useful this feature would be. I’m trying to understand your use case to see what problem you’re trying to solve.
Could you give me more details?
I have requested this feature years back. But didn't see any progress, just checking what the status is ?? I think auto commit will be a great idea for source control. We don't always want to add a comment to check in. If I link a project to a schema it keeps on tracking the changes I can go back to a certain date and check what was changed, which can also help us for auditing...
Martine Vanasse commented
Source Control for Oracle is used for SVN backup purpose of production database.
Deployment process into production database is authhorized with SQL scripts only.
development team do not have access in production database to deploy with redgate Tools.
Presently, instead of running refresh manually with source control each day, need a kind of scheduler task who periorically commit changes into SVN and send report to validate exceptions if needed.
Indeed, our main purpose for this request is in line with your DLM Dashboard for SQL Server.
OK this does sound like I presumed a possible scenario for a new tool we're developing called DLM Dashboard. Currently it's only for SQL Server although we're looking into the possibility of creating Oracle version.
Hi, for audit trailing purposes, it is required to track the changes made on the database either due to a new schema deployment on the production database environment or any database environment. This helps to detect changes easily and to rectify if required.
any news regarding this request.
I'm also interested in the ability to permanently automated check-in of any changes on our PRD_DB into SVN.