Commandline Source control
It would be great if we could integrate SQL Source Control with our build scripts. For example a simple command line command to get the latest changes and apply (or script) them to our staging environment would be great. Or a command to commit all changes to source control.
Anonymous
shared this idea
-
Richard Green
commented
We're trying to automate linking databases to source control (we already have PowerShell scripts that will create clones and azure projects, clone the central repo to a local repo and do an initial commit but cannot automatically link the clone to the local repo.
This would save us a lot of time and stop a lot of human error. -
saul
commented
David, are there any examples on how to do this, in particular our use case is the following:
A vendor deploys a database every day in a particular server, then we get the schema out of this database, and have to manually alter our local database (the one that is linked to SQL Source Control) and commit all changes, then push these commits to Github (also using SQL Source control and or Git bash), how can we do the commit part using cmdlets?, I guess that I could make the database changes to my local following the same steps we do for any release to an environment, however I'm unable to find an example on how to commit these changes to my sql source control working directory :)
-
This should be straightforward using the existing command line tool of your VCS (sg svn.exe or git.exe) alongside the DLM Automation commandlets.
