How do I use the AT Internal Database?

The Archivists’ Toolkit now includes (AT 2.0, update 9 and later), support for an internal database based on HyperSQL 2.0 (HSQLDB). For installation instructions, click on the pdf below.

• If I am using the internal database, can I transfer to it data from another database such as MySQL, MS SQL Server, or Oracle?

No, we currently don’t support the migration of data between any of the database types supported by the AT, including the internal database.

• How much data can I store in the Internal Database?

The amount of data that can be stored is limited only by the available disk space on the user’s computer.

• How do I create a backup of the Internal Database?

First, shut down the AT if it is running. Then search for the “at_db” folder in your “Documents and Settings” folder if you use Windows, or in your home directory if you use Mac OS X or Linux. Once you locate the folder, create a zip archive of it. This is your backup file and it can be restored by simple deleting the "at_db" folder (if one exists), then unzipping it, in the same location. You can also move this backup file to another computer and unzip it in the appropriate folder as a way to share this data.

• How do I re-initialize the Internal Database and start fresh with an empty version?

In the event you need to re-initialize the Internal Database, simply delete the “at_db” folder and run the Maintenance Program to initialize it as before.

• If I upgrade my version of the AT and had an Internal Database setup, do I have to run the Maintenance Program again to initialize the Internal Database again?

No, updating the version of the AT, doesn't require the Internal Database to be initialized again.

• Can I provide access to the Internal Database over a network. For example, I want multiple people to share data like with MySQL, MS SQL Server, or Oracle?

Yes, since the Internal Database is based on HyperSQL, then it can be setup to allow network connections from multiple AT instances. However, we currently provide no technical support for doing this: you will have to consult the HyperSQL User Guide for information on how to accomplish this. Please note, that we advise only users with strong technical backgrounds to attempt this process.

ATInternalDatabaseInstallationProcedures.pdf1.66 MB