Generate change script for a commit
KdL
Posts: 1 New member
Is there a way to generate a script of the changes being committed? We have a third-party developer who needs to reference our database changes, but has no access to our network; we would like to be able to provide the committed changes as an SQL script.
Tagged:
Answers
https://documentation.red-gate.com/sca/developing-databases
2. If you want to stick with SQL Source Control, you can set up an automated build task using the SQL Change Automation PowerShell cmd-lets:
https://documentation.red-gate.com/sca/reference/powershell-cmdlets
For example, if you created a new DatabaseReleaseArtifact for each commit, using the latest source control version as the source and the prod DB (or a copy of the prod DB) as the target, you could publish this release artifacts to a shared location.
That release artifact will contain:
- Copy of source schema
- Copy of Target schema
- Human readable diff report with any warnings etc
DevOps Mentor and Coach
Director of DLM Consultants
Creator of Speaking Mentors
Microsoft Data Platform MVP
Friend of Redgate
Twitter / LinkedIn