Creating a snapshot via the toolkit

interact · July 16, 2007 2:36PM

I purchased the SQL ToolKit in January. Can I create a snapshot via the toolkit. I have created a .NET application that compares two databases, but I want to create a .NET application to create a snapshot for a given database. Is there a way to do this?

Brian Donahue · September 10, 2007 4:39PM

Thanks for asking. This is fairly easy to do. First, create a new instance of the Database object. Next, invoke the .Register method. After registration, you have a representation of the database schema in a temporary file already. To save the snapshot, invoke SaveToDisk() on the database object. This will save it to a file that you specify.

David Atkinson · July 22, 2008 5:10AM

Hi,

If it helps, we now have a free tool that can create snapshots:

http://www.red-gate.com/MessageBoard/viewforum.php?f=81

Kind regards,

David Atkinson
Red Gate Software

Creating a snapshot via the toolkit

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk