Hi,
We are designing a windows application where we need to 'Get tables and columns from existing sql server snapshot file or backup file' .
Does anybody know how it can be done.
Please provide help.
Thank you.
team_ferrari22 0 Newbie Poster
shine_jose -6 Light Poster
Hi,
We are designing a windows application where we need to 'Get tables and columns from existing sql server snapshot file or backup file' .Does anybody know how it can be done.
Please provide help.Thank you.
For restoring backup file
1)Create a database with same name
2)Go to enterprise manager in sql
3)Expand the console root select the server where new database created exist.
4) right click database select all task restore database select the backup file
team_ferrari22 0 Newbie Poster
Hi,
Actually we are not going to use the backup & restoring techniques of sql server.
Simply we want to allow user to select a backup/snapshot file and our application has to list & display the Tables & columns names which are there in those files. Here we will not use any sql Connection String.... we want to get info in offline manner.
Thank you for replying.
sknake 1,622 Senior Poster Featured Poster
If that functionality exists it would be in SMO:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backupdevice_members(SQL.90).aspx
I looked around but didn't see anything at a glance
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.