Create snapshot with SQL change automation

ewew5087 · March 31, 2020 12:47PM

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 · March 31, 2020 3:43PM

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 · March 31, 2020 1:27PM

@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 · March 31, 2020 2:50PM

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 · March 31, 2020 3:05PM

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

ewew5087 · March 31, 2020 3:36PM

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.

Create snapshot with SQL change automation

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk