Comments
2 comments
-
You will be able to do this using the SQL Toolkit. However this will require you to write your own small application.
Have a look through the online SQL Toolkit help file. Especially the sample API section which includes sample code for saving a snapshot.
http://help.red-gate.com/help/SQLCompar ... frame.html -
Hi,
We now have a free tool that can create snapshots:
http://www.red-gate.com/MessageBoard/viewforum.php?f=81
However, this tool will create snapshots for SQL Compare v7, so please upgrade to this version if you haven't done so already.
Kind regards,
David Atkinson
Red Gate Software
Add comment
Please sign in to leave a comment.
I have SQL Compare installed on my workstation, and it works great for comparing databases on all the servers I have access to.
However I often also need to compare database on various client servers that are behind firewalls. I don't want to purchase another license for a one-off use, and wouldn't want to install it on a client's production server anyway.
Is there a simple tool that could be run without an installation process just create a snapshot? I could then download the snapshot and do all the comparison and script generation locally. It could also be something I could automate with some instructions and have clients generate and send me a snapshot themselves.
I know I could backup and restore the database too, but some of them are enormous ... and this is quite time consuming. Also, the data itself is sometimes sensitive, and the client would often be reluctant to let a backup outside the network.
Any ideas appreciated.
Thanks
Ben