Select query on BackupSetDatabase?

[hemantgaur]

I am comparing two databases. One of them is BackupSetDatabase. I would like to run a select query on this backup. What is the best way of doing this? Is there a Red-gate API which can give me the result? Do you have an example of this in your knowledge base?

Would deeply appreciate your help on this.

Thank you.

[Chris Auckland]

Thanks for your post.

You cannot use the API to runs specific queries against a backup file, it only supports using the backup file as a data source for the comparison.

Do you want to be able to interrogate the offline backup file?
_________________
Chris

[hemantgaur]

yes.... ideally...

but if not, then is there a way to do it against an attached database?

[Chris Auckland]

The SDK dosn't have wny methods to do this, but if the database is online, then you can query the database using a .net sqlconnection.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx
_________________
Chris