Using the Takeout Database Tool
Use the Takeout Database Tool to perform automatic functions on the Aloha Takeout database. Use this utility only during installation and before the store goes live, unless instructed by a support team member.
You can use the Takeout Database Tool to:
Create — Creates a new blank Aloha Takeout SQL database with the current schema version. If the Aloha Takeout service detects a database is attached to SQL Express, this button is not available. Aloha Takeout creates the SQL Express database during the Server installation; however, you can use this button if the database becomes detached, is deleted, or is renamed by mistake.
Attach — Attaches a database to SQL Express for use with Aloha Takeout in the event the database becomes detached. If the Aloha Takeout service detects a database attached to SQL Express, this button is not available.
Upgrade — Migrates the database to the current schema version. The Aloha Takeout installation process updates the database to the current schema version; however, in the event you need to restore a backup from a previous schema version, the Standard or Training database versions, shown at the bottom of the screen, may not be in sync. If they do not match, they appear in read. Matching versions appear in green.
Reset — Clears all customer and order data from the database. Use Reset to clear all current and historical customer and order data entered during training before 'going live.'
Repair — Repairs encryption issues on the Takeout database.
Encrypt — Encrypts all Personal Identity Information (PII) in the Takeout database.
Note: The Repair and Encrypt options can take several hours to complete for some databases. The process may appear frozen because of the time required. Allow sufficient time for the process to complete.
Rebuild Idxs — Rebuilds the encrypted PII indexes after repair or encryption.
Caution: Do not use the Reset function once the store is actively adding customers and creating takeout orders.