Show TOC

Procedure documentationReloading a Table

Procedure

Reloading a table that has been unloaded is slightly different than reloading an entire database that has been unloaded. Regardless of what is unloaded from the database, the reload.sql file is identical. It is created to reload the entire database even if only one or two tables have been unloaded. Because of this fact, when reloading tables you must use only the portions of the reload.sql file that relate to the specified tables.

  1. Locate the reload.sql file (located by default in the C:\Program Files\Triversity Databases directory) and open it using Microsoft Wordpad.

  2. Click the Edit menu, and then click Find.

  3. In the Find What field, type the name of the table you have unloaded, and then click Find Next. If you have unloaded more than one table, search for all entries of a given table before searching for another table (that is, search for one table name at a time).

  4. Highlight the full SQL command surrounding the required table name for every mention of the name that is found in the reload.sql file.

  5. Right-click any portion of the highlighted SQL command, and then click Copy.

  6. Open ISQL.

  7. In the ISQL window, right-click the Command section (at the end of any previously pasted commands) and then click Paste.

  8. Repeat steps 2 through 7 until all SQL commands referencing the unloaded table(s) are copied from the reload.sql file into the Command section of the ISQL window.

  9. Click Execute to reload the table(s).