If you have added, changed, or deleted many rows in your database, use the Reload option. Reload copies the open database table by table to a new database name that you specify, preserving the original database. As it duplicates the database, Reload places the rows for each table in a single area of your database data file (File 2), thereby eliminating unusable disk space. Reload does not have options that allow you to compress indexes or the database structure only.
To use the Reload option, you must have room for a copy of your database on your hard disk. If you do not have enough space on your hard disk, use the Pack In Place option to compress the database instead.
To compress the SkyWrite database files using Reload:
| 1. | If the SkyWrite database is not open, click the Databases tab in the Database Explorer and select "SkyWrite". |
| 2. | Click the Connect option. |
| 3. | From the R:BASE menu bar, select Utilities: Reload |
You will be prompted to enter a new database name.
| 4. | Enter SkyWrite2 and select the "Save" button. |
After the process is complete, you will see the additional database with the name SkyWrite2 listed in the Database Explorer. Once you are sure that your new database is working properly, you can use the Database Explorer to rename or delete the old database files and rename the new files to the original database name.
