Hi,
We are designing a windows application where we need to 'Get table and column names from existing sql server snapshot file or backup file' .
Does anybody know how it can be done. Please provide help.
Thank you.
views:
148answers:
2
A:
Can you just restore the backup programmatically, then check like you normally would (information_schema, etc)?
If not, all I can suggest is to look at http://www.idera.com/Products/SQL-toolbox/SQL-virtual-database/
Blorgbeard
2010-01-20 05:55:08
team-ferrari22
2010-01-20 09:02:03
+1
A:
- Backup file: no
- Snapshot: it's just another database
I reckon it's worth looking at How Database Snapshots Work to ensure your requirements make sense...
gbn
2010-01-20 06:00:11
team-ferrari22
2010-01-20 09:03:15
In which case, you can't. You need to have an active SQL Server database with a SQL connection string: there is no way to read a backup or snapshot file.
gbn
2010-01-20 11:25:30