Sql Source Control - get list of changes to database
dpimental
Posts: 2 New member
all, if I have added a database to source control and then update a view, there will be visual cues that the view has changed. So my question is this, is there a way, by a command line to get a list of any changes to the database?
Tagged:
Answers
Thank you for reaching out.
Unfortunately, this type of functionality is not available through the command line.
Product Manager
Redgate Software
I would like some technical support with both Sql Source Control and Flyway. I know you know longer support sql source control.
My goal would be to add a database's views, functions and stored procedures to Git. Then run a Windows Scheduler which calls a PowerShell script. The script would do the following ...
1. Run a query against sys.objects to see recent changes to the database.
2. Call the command to add / commit the latest changes in the database to our Git repository using either Redgate Sql Source Control or Redgate Flyway.
3. Get the latest version of the repository and pull it down to the local repository.
4. Send out email notifications about changes in the database that have been committed to git.
Can you have one of the technical support staff contact me for some help on this?
Thanks.