How can we help you today? How can we help you today?

Take snapshot of customer database

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
0

Comments

3 comments

Sort by
  • 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...
    Per Hultqvist
    0
  • 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
    jammin
    0
  • 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...
    Per Hultqvist
    0

Add comment

Please sign in to leave a comment.