Free schema snapshot utility: SQL Snapper

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Free schema snapshot utility: SQL Snapper

Postby David Atkinson » Mon Jul 21, 2008 4:28 pm

SQL Snapper is a free utility that creates a SQL Compare schema snapshot of a SQL Server 2000, 2005 or 2008 database. This snapshot can then be used as a database source in Red Gate's SQL Compare. You will find SQL Snapper useful when you have databases deployed at a customer's site, and you need to use SQL Compare to compare the schema of a remote databases with your reference database. If the remote database cannot be accessed from your machine, you can ask your customers to use SQL Snapper to create a SQL Compare snapshot of their database’s schema, and send the snapshot file to you. You can then load the snapshot into SQL Compare, and generate the appropriate upgrade script for the customer.

This release of Snapper generates SQL Compare snapshots that work with SQL Compare 7.0 or later.

SQL Snapper can be downloaded from ftp://support.red-gate.com/utilities/freetools/Old_Labs/Red%20Gate%20Labs%20-%20Stuff/RedGateSnapper.htm

David Atkinson
Red Gate Software
Last edited by David Atkinson on Fri Apr 20, 2012 5:34 pm, edited 2 times in total.
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Command line

Postby Stefano Paparesta » Tue Jul 22, 2008 11:14 am

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

Stefano Paparesta
Stefano Paparesta
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

verey usefull tool

Postby foths » Tue Jul 22, 2008 12:45 pm

:D 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! :wink:
foths
 
Posts: 1
Joined: Tue Jul 22, 2008 12:29 pm

Postby Stefano Paparesta » Tue Jul 22, 2008 2:07 pm

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
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

Very useful tool.

Postby aperregatturv » Tue Jul 22, 2008 3:33 pm

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
 
Posts: 48
Joined: Wed Aug 31, 2005 3:11 pm
Location: New York

Postby Stefano Paparesta » Thu Aug 28, 2008 1:49 pm

Hi guys,
any news on command line interface for the snapper ?
Thanks

Stefano
Stefano Paparesta
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

Postby David Atkinson » Thu Aug 28, 2008 2:01 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby aperregatturv » Thu Aug 28, 2008 2:20 pm

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
 
Posts: 48
Joined: Wed Aug 31, 2005 3:11 pm
Location: New York

Postby jerryhung » Thu Aug 28, 2008 2:27 pm

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
Jerry Hung
DBA, MCITP
jerryhung
 
Posts: 113
Joined: Fri Dec 28, 2007 5:12 pm

Postby Stefano Paparesta » Mon Sep 01, 2008 5:35 pm

For me Commandline version + xml config it's very important feature

Thanks
Stefano Paparesta
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

SQL Snapper Command Line

Postby elliotm » Fri Sep 05, 2008 11:20 am

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
 
Posts: 1
Joined: Fri Sep 05, 2008 10:52 am
Location: Cambridge, UK

Postby jerryhung » Fri Sep 05, 2008 6:30 pm

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 :)
Jerry Hung
DBA, MCITP
jerryhung
 
Posts: 113
Joined: Fri Dec 28, 2007 5:12 pm

Postby Stefano Paparesta » Mon Sep 08, 2008 8:40 am

For me this command line args it's ok... :wink:
Stefano Paparesta
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

Postby Stefano Paparesta » Tue Sep 23, 2008 8:15 pm

Hi,
when you release the command line interface ??
Thanks
Stefano
Stefano Paparesta
 
Posts: 21
Joined: Wed May 17, 2006 11:31 am

Postby David Atkinson » Wed Oct 22, 2008 12:54 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Next

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 2 guests