Feature Request for next Version of SQL Backup
abuttery@impactrx.com
Posts: 20
Occasionally I have the need to look at the data in a table from an archived backup of a database. I would really appreciate the ability to restore just a single table with a new name to an existing database or with the existing name to a new database from a SQL Backup backup file.
Right now, I have to restore the entire database to a "test" database and then pull out the table that I need to interrogate and then drop the "test" database.
Right now, I have to restore the entire database to a "test" database and then pull out the table that I need to interrogate and then drop the "test" database.
Comments
You might like to have a look at SQL Compare and SQL Data Compare, if you're trying to pull individual objects out of a backup.
SQL Data Compare 6 and later ("Pro" edition) can ready data directly from a backup file, and synchronise it into a live database, so if you've already got a way of recreating an empty table into which you can pull the data, that should do the trick. You can also chose the data to import on a row-by-row basis, or compare a backup to a live database, if you're just looking at the changes made over a period of time.
In SQL Compare 7 Pro, which should be coming out fairly soon now, you'll also be able to do the same for the schema, so even if you don't have the schema available, you can pull that out from the backup.
Hope that helps,
Robert
Red Gate
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
http://www.simple-talk.com/community/blogs/brian_donahue/archive/2008/08/16/68713.aspx
SQL Backup Project Manager
Red Gate Software