January 21st, 2010, 03:10 AM
Get tables and columns from existing sql server backup file
How to get tables and columns from existing sql server backup file without connect to SQL Server?
Is it possible to get table names and column names form raw file like *.bak ?
I would like to display the Tables & columns names which are there in backup file. Here we will not use any sql Connection String.... ( without connecting SQL Server)
Please help me.............
January 21st, 2010, 07:46 AM
Re: Get tables and columns from existing sql server backup file
Well. You can scan through the backup file and find a way identifying the tables in there. I'm not sure how easy this given that SQL Server is likely to be using a proprietary format. Can I ask why you can't use SQL Server to do this? Then you would be able to SQL Server Management Objects. These are classes that allow you to perform a host of operations against a SQL Server database like restoring backups, etc.
Click Here to Expand Forum to Full Width