How can I restore a single table in SQL 7?

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!


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish