Red Gate forums :: View topic - Free schema snapshot utility: SQL Snapper
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Free schema snapshot utility: SQL Snapper

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Go to page Previous  1, 2
Author Message
jerryhung



Joined: 28 Dec 2007
Posts: 116

PostPosted: Wed Oct 22, 2008 2:31 pm    Post subject: Reply with quote

Downloaded, thanks
Version: 7.5.0.28

Code:

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
Back to top
View user's profile Send private message
AndrewMurphy



Joined: 25 Jan 2007
Posts: 15
Location: Ireland

PostPosted: Tue Oct 28, 2008 11:33 am    Post subject: Reply with quote

Spam from Kate???
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6649

PostPosted: Tue Oct 28, 2008 11:59 am    Post subject: Reply with quote

Thanks Andrew! I've deleted the previous post and killed the katei4 user account as it's only been used to create spam.
Back to top
View user's profile Send private message
DBNovice



Joined: 12 Nov 2008
Posts: 3

PostPosted: Wed Nov 12, 2008 11:46 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Wed Nov 12, 2008 12:09 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
DBNovice



Joined: 12 Nov 2008
Posts: 3

PostPosted: Wed Nov 12, 2008 12:25 pm    Post subject: Reply with quote

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,
Back to top
View user's profile Send private message
Simon C



Joined: 26 Feb 2008
Posts: 140
Location: Red Gate Software

PostPosted: Wed Nov 12, 2008 2:22 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message Send e-mail
DBNovice



Joined: 12 Nov 2008
Posts: 3

PostPosted: Wed Nov 12, 2008 8:14 pm    Post subject: Reply with quote

Simon,

Good links.

Thanks, for the clarification.
Back to top
View user's profile Send private message
stevepatches



Joined: 29 Nov 2005
Posts: 7

PostPosted: Wed Jan 28, 2009 3:21 am    Post subject: SQL Snapper support scripts snapshot? Reply with quote

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 Smile
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Wed Jan 28, 2009 10:27 am    Post subject: Re: SQL Snapper support scripts snapshot? Reply with quote

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 Smile


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
Back to top
View user's profile Send private message Send e-mail
Stefano Paparesta



Joined: 17 May 2006
Posts: 22

PostPosted: Tue Mar 03, 2009 10:22 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Tue Mar 03, 2009 3:29 pm    Post subject: Reply with quote

Hi Stefano,

Yes, snapshots generated by SQL Snapper should be compatible with SQL Compare 8.0 (please tell us if they aren't Smile)
Back to top
View user's profile Send private message
Tobias279



Joined: 10 Jan 2014
Posts: 1

PostPosted: Fri Jan 10, 2014 10:45 am    Post subject: Decrypt encrypted objects on 2005 and 2008 databases Reply with quote

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
Back to top
View user's profile Send private message
bsleik



Joined: 04 Apr 2014
Posts: 1
Location: Calgary Canada

PostPosted: Fri Apr 04, 2014 10:34 pm    Post subject: What DB privileges are required to run SQL Snapper Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page Previous  1, 2
Page 2 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group