Create snapshot with SQL change automation

ewew5087

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?

David Atkinson

I 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

@ewew5087 This is possible using the sqlcompare.exe command line. Can you give more background on the problem you are trying to solve, as this helps us best answer the question?

ewew5087

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.

David Atkinson

@ewew5087 - After you've checked in the snapshot to TFS, is it used elsewhere? What is its purpose?

ewew5087

We keep snapshot in TFS.
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.