Create snapshot with SQL change automation

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 AtkinsonDavid Atkinson Posts: 1,384 Rose Gold 2
    Accepted Answer
    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
    Product Manager
    Redgate Software

Answers

  • @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
    Product Manager
    Redgate Software
  • ewew5087ewew5087 Posts: 6 New member

    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 - After you've checked in the snapshot to TFS, is it used elsewhere? What is its purpose?

    David Atkinson
    Product Manager
    Redgate Software
  • ewew5087ewew5087 Posts: 6 New member
    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.
Sign In or Register to comment.