Create snapshot with SQL change automation

• 
  @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?
  
  

  David Atkinson March 31, 2020 13:27

  - 0 +
• 

  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.

  ewew5087 March 31, 2020 14:50

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

  David Atkinson March 31, 2020 15:05

  - 0 +
• 
  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.
  

  ewew5087 March 31, 2020 15:36

  - 0 +
• 
  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 15:43

  - 0 +

Add comment

Please sign in to leave a comment.