Take snapshot of customer database

Per Hultqvist

Hi,

Sometimes I suspect that my customers have errors in the databaselayout (maybe because of errors in previous upgrade scripts, or some other external factor) and to verify this I always need them to send me a backup. This works of course, but not all customers agree to that. The database may contain sensitive data.

Then I realized that it would be great if I could make my application take a snapshot, using some SQL Compare-component, and then have the customer email me the snapshot (which does not conatin sensitive data).

Is this possible? Would you consider building such a tool/component?

Per Hultqvist

After doing some more searching in the forum and experimenting in VS.Net i got to work. That was easy, only three lines of code and two references :-)

Guess all i need now is a licens for the SQL Toolkit...

jammin

Ahh I just posted a request for something similar to this ... any chance you could provide a bit more info on the solution you found?

Many thanks
Jammin

Per Hultqvist

jammin wrote:

Ahh I just posted a request for something similar to this ... any chance you could provide a bit more info on the solution you found?

Many thanks
Jammin

Sorry Jammin, I didn't see your request until today when I got an email from redgate announcing this tool :

http://www.red-gate.com/MessageBoard/vi ... php?t=7312

I am looking forward to try this one out...