Free schema snapshot utility: SQL Snapper

Forum for users of SQL Compare schema synchronization utility

Moderators: JonathanWatts, Chris Auckland, David Atkinson

Postby jerryhung » Wed Oct 22, 2008 2:31 pm

Downloaded, thanks
Version: 7.5.0.28

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

Postby AndrewMurphy » Tue Oct 28, 2008 11:33 am

Spam from Kate???
AndrewMurphy
 
Posts: 15
Joined: Thu Jan 25, 2007 12:35 pm
Location: Ireland

Postby Brian Donahue » Tue Oct 28, 2008 11:59 am

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby DBNovice » Wed Nov 12, 2008 11:46 am

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
 
Posts: 3
Joined: Wed Nov 12, 2008 11:33 am

Postby David Atkinson » Wed Nov 12, 2008 12:09 pm

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

Postby DBNovice » Wed Nov 12, 2008 12:25 pm

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
 
Posts: 3
Joined: Wed Nov 12, 2008 11:33 am

Postby Simon C » Wed Nov 12, 2008 2:22 pm

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
 
Posts: 140
Joined: Tue Feb 26, 2008 4:56 pm
Location: Red Gate Software

Postby DBNovice » Wed Nov 12, 2008 8:14 pm

Simon,

Good links.

Thanks, for the clarification.
DBNovice
 
Posts: 3
Joined: Wed Nov 12, 2008 11:33 am

SQL Snapper support scripts snapshot?

Postby stevepatches » Wed Jan 28, 2009 3:21 am

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
 
Posts: 7
Joined: Tue Nov 29, 2005 3:46 pm

Re: SQL Snapper support scripts snapshot?

Postby David Atkinson » Wed Jan 28, 2009 10:27 am

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

Postby Stefano Paparesta » Tue Mar 03, 2009 10:22 am

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

Postby alice.easey » Tue Mar 03, 2009 3:29 pm

Hi Stefano,

Yes, snapshots generated by SQL Snapper should be compatible with SQL Compare 8.0 (please tell us if they aren't :))
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Decrypt encrypted objects on 2005 and 2008 databases

Postby Tobias279 » Fri Jan 10, 2014 10:45 am

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
 
Posts: 1
Joined: Fri Jan 10, 2014 10:39 am

What DB privileges are required to run SQL Snapper

Postby bsleik » Fri Apr 04, 2014 10:34 pm

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
 
Posts: 1
Joined: Fri Apr 04, 2014 10:30 pm
Location: Calgary Canada

Previous

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 2 guests