Create snapshot with SQL change automation
ewew5087
Posts: 6 New member
I would like create a project to use SQL change automation to create SQL snapshot in my VS2019 is there any document or example I can see it?
Tagged:
Best Answer
-
David Atkinson Posts: 1,461 Rose Gold 2I see. Your best bet might be to use the Snapper utility's command line for this step. This is a tool that you can find in your SQL Compare install folder. More details here.David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software
We used SQL SDK11 as reference to create a tool for deploy database. According to Redgate support, they do not support SDK11 we need convert our tool to use SQL change automation.
Here is step how do we create branch on database part.
1.Create Database backup.
2.Take snapshot.
3.Check snapshot into TFS.
4.Run database compare including data.
5.Create script.
6.Deploy to target.
Product Manager
Redgate Software
When developers make change on the other environments, we use theses snapshot to compare their change and create script and merge back to development environment for next release.