automating commits (github)

Mike_Vessey77

I'm in a bit of a halfway house here at the minute. We aren't quite ready to block everyone from developing on live (yes , I know it's bad)

so, to start with we are keeping our source control repository up to date by using the Redgate tools and we check what has changed between live and source code (again … I know its not perfect)

the main aim is for developers to develop on their local machine (not so easy, we have lots of linked servers and things that don't build on local.... yet)

but I have maybe 400 databases and I know I can't do this manually. Is there any way I can script "get latest" and "commit" and "Push"?


I don't need a loop or any of that stuff, just how to do those for one database.. I can figure out the rest


Thanks

Tianjiao_Li

It is not possible to automate commits as there are risks like unwanted changes will get committed.

In SQL Source Control, commits should be done interactively on SSMS. Should you wish to have this ability, please kindly post it on the user voice forum and there is a similar one already.

Thanks.