How can I restore a single table in SQL 7?

Neil Pike

July 19, 1999

1 Min Read
ITPro Today logo

A. You can't directly - LOAD TABLE is no longer supported. You will have to restore the database dump to a different server/database and then extract out the table in question using DTS/BCP.

You CAN restore a single file with SQL 7 though so if you place a table in a file on it's own then you'll be able to restore it. For SAP systems with 1000's of tables the admin of having separate files would be a nightmare though!

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like