Free schema snapshot utility: SQL Snapper

• 
  :lol: THANKS for this tool,
  you have any plain to add the command line interface ? :oops:
  
  Stefano Paparesta

  Stefano Paparesta July 22, 2008 06:14

  - 0 +
• 
  very usefull tool, ive been expecting it!
  
  some more things we need:
  
  -deployment:
  --self extracting single zip exe file
  -configuration of behaviour
  --command line options
  --config file
  
  it would be nice for me to be able to send to the client 2 files:
  -the single self-extracting zipped exe file for the deployment
  -a .BAT file, with command line arguments, already there by me, so the client wont have to do anything at all, only double click the .bat file i will send to him (provided of course, i know at least the database name and server).
  
  thanks!

  foths July 22, 2008 07:45

  - 0 +
• 
  Yes, for me too the config file and the command line is fundamental. I don't wont my client insert any config data (server name and db name), and i want integrate the generation of snapshot in a simple pipeline :
  1 - Generate snapshot
  2 - create email msg
  3 - attach snapshot to email
  4 - send email
  
  for this operation :shock: i need a command line interface like SqlCompare Pro and xml file config.
  Regards
  
  Stefano

  Stefano Paparesta July 22, 2008 09:07

  - 0 +
• 
  when RedGate released 6.0. I created my own utility [SnapshotCreator] to create snapshot because of the same reason Red Gate created SQLSnapper for.
  
  The only problem i have with this SQLSnapper utility is that when i send this utility to customers I want them to see the utility is created by us and not RedGate.
  
  If its possible to add config file to Show/Hide the Image and of course a commandline interface will be a big help.
  
  for deployment for such small utility i use Inno Setup [freeware installer]
  which is almost like a Self extractor.
  http://www.jrsoftware.org/isdl.php
  If someone needs it i can send you the script file for it.
  
  
  Thanks
  Arun[/url]

  aperregatturv July 22, 2008 10:33

  - 0 +
• 
  Hi guys,
  any news on command line interface for the snapper ?
  Thanks
  
  Stefano

  Stefano Paparesta August 28, 2008 08:49

  - 0 +
• 
  We're still waiting for more user feedback on SQL Snapper before considering what may go into the next version. So it's unlikely that we'll put any serious effort into it until that point.
  
  Do you want a command line version or simply a UI version that is auto-populated based on values you've provided in a config file?
  
  David Atkinson
  Red Gate Software

  David Atkinson August 28, 2008 09:01

  - 0 +
• 
  Top priority for me will be Commandline
  SQLSnapper -sServer -dDatabase -uUser -pPwd -snp Snapshot path.
  
  or even Config file will be great but i don't want to add user id or password in there.
  I can create a utility to call SQLSnapper with command line parameters.
  
  
  Thanks

  aperregatturv August 28, 2008 09:20

  - 0 +
• 
  I think I'll go for a Command Line option too, just so I can schedule it (and possibly download automatically to be used for comparison in DEV/UA/STAGING)
  
  It is a great product though, I can compare a Production DB without actually download & restoring them

  jerryhung August 28, 2008 09:27

  - 0 +
• 
  For me Commandline version + xml config it's very important feature
  
  Thanks

  Stefano Paparesta September 01, 2008 12:35

  - 0 +
• 
  We have had a number of requests to provide a command line for SQL Snapper. Below is the text of the help associated with the command line and I hope you can give feedback on whether this is appropriate for your needs…
  
  
  Elliot Matthew
  
  Red Gate Software
  
  
  SQL Snapper V1.0.0.0
  ==============================================================================
  Copyright Copyright © Red Gate Software Ltd 2008
  
  RedGate.SQLSnapper.exe -
  
  Options
  =======
  
  /database:<database> (Alias: /db)
  The name of the database to create a snapshot of.
  
  /username:<username> (Alias: /u)
  The username for the database.
  
  /password:<password> (Alias: /p)
  The password for the database.
  
  /server:<server> (Alias: /s) [Default: (local)]
  The name of the SQL server.
  
  /makesnapshot:<makesnapshot> (Alias: /mksnap)
  Creates a snapshot of the database with the path specified.

  elliotm September 05, 2008 06:20

  - 0 +
• 
  Command line syntax help look good to me for our current usage
  perhaps support Windows Authentication on top of user/password as well
  
  now the question is when we can expect it

  jerryhung September 05, 2008 13:30

  - 0 +
• 
  For me this command line args it's ok...

  Stefano Paparesta September 08, 2008 03:40

  - 0 +
• 
  Hi,
  when you release the command line interface ??
  Thanks
  Stefano

  Stefano Paparesta September 23, 2008 15:15

  - 0 +
• 
  SQL Snapper with command line capability is now available from our labs page:
  
  http://labs.red-gate.com/index.php/Red_Gate_Snapper
  
  Please let us know what you think.
  
  Thanks,
  
  David Atkinson
  Red Gate Software

  David Atkinson October 22, 2008 07:54

  - 0 +
• 
  Downloaded, thanks
  Version: 7.5.0.28
  

  RedGate.SQLSnapper.exe /?
  
  SQL Snapper V7.5.0.28
  ==============================================================================
  Copyright Copyright c Red Gate Software Ltd 2008
  
  RedGate.SQLSnapper.exe -
  
  
  Options
  =======
  /help (Alias: /?)
      Displays this help message. Use in conjunction with /verbose for more
      detailed information.
  /html
      Causes help to be output as HTML.
  /quiet (Alias: /q)
      Quiet mode - no output.
  /verbose (Alias: /v)
      Verbose mode.
  /database:<database> (Alias: /db)
      The name of the database to create a snapshot of.
  /username:<username> (Alias: /u)
      The username for the database.
  /password:<password> (Alias: /p)
      The password for the database.
  /server:<server> (Alias: /s) [Default: (local)]
      The name of the SQL server.
  /makesnapshot:<makesnapshot> (Alias: /mksnap)
      Creates a snapshot of the database with the path specified.
  

  
  
  I do have a question regarding user
  - does it support Windows Authentication? if so how?
  The GUI interface supports Mixed mode so that's why I asked

  jerryhung October 22, 2008 09:31

  - 0 +
• 
  Spam from Kate???

  AndrewMurphy October 28, 2008 06:33

  - 0 +
• 
  Thanks Andrew! I've deleted the previous post and killed the katei4 user account as it's only been used to create spam.

  Brian Donahue October 28, 2008 06:59

  - 0 +
• 
  Hi,
  
  I am interested if the RG snapshot is compatible with SQL SERVER snapshot format?
  
  When I said that I meant:
  Can I use RG snapshot from MSSMS, or can I use MSSMS snapshot from RG tool.
  
  If yes please confirm, if no: What are your future plans regarding snapshots?
  Do you have plans to use
  a) the same format for snapshots as Microsoft?
  b) compatible format with Microsoft snapshots?
  
  MS SMS stands for Microsoft SQL Server Management Studio
  Thanks

  DBNovice November 12, 2008 05:46

  - 0 +
• 
  SQL Compare schema snapshots are not the same thing as SQL Server Snapshots. Admittedly the naming is a little unfortunate.
  
  SQL Compare will read from its own snapshot, which doesn't store any data. The other supported formats are:
  
  1) database
  2) backup
  3) set of scripts
  
  I'd be curious to know what sort of compatibility you had in mind?
  
  Kind regards,
  
  David Atkinson
  Red Gate Software

  David Atkinson November 12, 2008 06:09

  - 0 +
• 
  Hi,
  
  Thanks for the kind reply, I am getting the picture now.
  
  Unfortunately I cannot say it precisely because I don't have enough knowledge regarding snapshots (RG ones nor Microsoft's), but I can share with you that I believed it is possible to use only Microsoft snapshots in RG tool as snapshots Data Soruce.
  
  I also believe that probable the Microsoft snapshot format is not optimal for the purpose you need in RG, so you needed something better than that.
  
  Thanks,

  DBNovice November 12, 2008 06:25

  - 0 +
• 
  Just to be clear, a SQL Server snapshot is treated as a separate database within SQL Server, but is actually stored as the differences from the snapshotted database from a particular point in time (when the snapshot was created), and overwritten data on the source database is copied into the snapshot as it gets updated - see http://msdn.microsoft.com/en-us/library/ms175158.aspx and http://msdn.microsoft.com/en-us/library/ms187054.aspx .
  
  A SQL Compare snapshot is a binary file containing a serialized version of the whole schema information from a database.
  
  Does that make things a bit clearer?

  Simon C November 12, 2008 08:22

  - 0 +
• 
  Simon,
  
  Good links.
  
  Thanks, for the clarification.

  DBNovice November 12, 2008 14:14

  - 0 +
• 
  Are there any plans to support the directory of scripts snapshot format in addition to the binary format? This would be very useful to me. Yes I know you get can them through SQL Management Studio but the RG tools are so much faster :-)

  stevepatches January 27, 2009 21:21

  - 0 +
• 

  stevepatches wrote:

  Are there any plans to support the directory of scripts snapshot format in addition to the binary format? This would be very useful to me. Yes I know you get can them through SQL Management Studio but the RG tools are so much faster :-)

  
  Hi Steve,
  
  We have no 'immediate' plans to do this, although we will consider this as an option if enough people ask for it. It helps us to understand how the functionality would be used. If you can describe the scenario and the problem you'd be solving with this, we will raise an enhancement request.
  
  Kind regards,
  
  David Atkinson
  Product Manager
  Red Gate Software

  David Atkinson January 28, 2009 04:27

  - 0 +
• 
  Hi all,
  now with the release of sql compare 8.0 you align the snapper with this version ? The snapshot format file product from snapper its ok for sql cmapre 8.0?
  Regards
  
  Stefano Paparesta

  Stefano Paparesta March 03, 2009 04:22

  - 0 +
• 
  Hi Stefano,
  
  Yes, snapshots generated by SQL Snapper should be compatible with SQL Compare 8.0 (please tell us if they aren't )

  Alice E March 03, 2009 09:29

  - 0 +
• 
  Hi,
  
  i have just found your toll SQLSnapper. Its fantastic for us because many of our customers have an own server that we can not reach from our systems. But if i use the snapper, i am missing the procedures an functions.
  Is there a chance to get them with SQL Snapper?
  
  regards
  
  Tobias

  Tobias279 January 10, 2014 04:45

  - 0 +
• 
  What DB privileges are required to run SQL Snapper? I don't get the object permissions generated in my SQL Snapshot. I know I used to get it when I had full database owner.
  
  The DBA may be willing to add read permissions to system tables or views if required.

  bsleik April 04, 2014 17:34

  - 0 +
• 
  I know this is old and has been asked, but see no response from anyone. We also would like a command line version of SqlSnapper.
  Thanks

  mmoore May 12, 2017 13:08

  - 0 +
• 
  @mmoore I'm not sure if it was added in the meantime, but the Snapper included in SQL Compare v12 does include a commandline - if you run

  RedGate.SQLSnapper.exe /help
  

  you can see more details.

  Mark J May 12, 2017 14:51

  - 0 +

Add comment

Please sign in to leave a comment.