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.
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 :)
AdminDavid Atkinson (Admin, Redgate) commented
This should be straightforward using the existing command line tool of your VCS (sg svn.exe or git.exe) alongside the DLM Automation commandlets.