Skip to content
← Oracle

How can we improve our Oracle solution?

Oracle: Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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] -
table1,
view1,
package1,
package2
function1"

(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.

21 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Abhinav shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Richard Mitchell responded  · 

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?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • arvind commented  ·   ·  Report

    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  ·   ·  Report

    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.

    Thank you.

  • Ivan commented  ·   ·  Report

    Indeed, our main purpose for this request is in line with your DLM Dashboard for SQL Server.

  • Herbert.Damm commented  ·   ·  Report

    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.

  • Anonymous commented  ·   ·  Report

    Hi All,

    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.

    Regards,
    Huynh.