Select query on BackupSetDatabase?

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Select query on BackupSetDatabase?

Postby hemantgaur » Mon Mar 08, 2010 10:26 pm

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.
hemantgaur
 
Posts: 20
Joined: Wed Dec 16, 2009 9:15 pm

Postby Chris Auckland » Wed Mar 10, 2010 9:56 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby hemantgaur » Thu Mar 11, 2010 7:27 pm

yes.... ideally...

but if not, then is there a way to do it against an attached database?
hemantgaur
 
Posts: 20
Joined: Wed Dec 16, 2009 9:15 pm

Postby Chris Auckland » Mon Mar 15, 2010 12:46 pm

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 ... ction.aspx
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron