Automatically Check for Changes and check those changes in periodically.
If I could have the product walk a bunch of databases on a server (like a dev server) at 4 PM every day and check in any changes either completely automatically or with a single click for all dbs that would be sweet.
Another use case for this is when I have to revoke a users rights to a bunch (20 or more) databases on a server with a script but then have to check in the change on each db one at a time.
Henry Treftz
shared this idea
-
Bryan Farrell
commented
This would be a great feature. Perhaps implement it as a service than runs on the SQL server. When a change is made to the server have the service analyse the SQL Logs, and if it is a qualifying change, automatically create a new version in source control. This would be ideal for the reasons mentioned above but would also be very beneficial in an environment where you do not have total control over the development process (ie. 3rd party vendor making customizations to their product at your request using offshore developers who report to the 3rd party vendor.) We have that situation and a feature like this would go a long way to make sure all changes are cataloged in the source control system on our dev environment.
-
Jordon Pilling
commented
Indeed, i have 5 servers, 2 developers (me being one of them) making half a dozen changes a day to 30+ databases, having to check them all separately its very tedious, and for this reason, new work can go a few days before being noticed and checked in.