Get tables and columns from existing sql server backup file
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Get tables and columns from existing sql server backup file

  1. #1
    Join Date
    Jan 2010
    Posts
    1

    Get tables and columns from existing sql server backup file

    Hi all,

    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.............

    Thanks
    Venkat

  2. #2
    Join Date
    Nov 2002
    Location
    .NET 3.5 VS2008
    Posts
    1,039

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center