The Advantage Data Architect (ARC) is a tool designed to assist you in efficiently developing and maintaining Advantage database applications. The Advantage Data Architect product can be downloaded from the Downloads page on the Advantage Database Server Web site, www.AdvantageDatabase.com
Development
While developing your database application ARC enables you to:
| • | Import other table types (such as Paradox, Btrieve, Access, etc.) to Advantage compatible tables |
| • | Create and maintain Advantage Data Dictionaries |
| • | Create tables and indexes |
| • | Restructure existing tables |
| • | Encrypt/decrypt tables and/or dictionaries |
| • | Test filters, scopes/ranges, and lookups |
| • | Generate and test Advantage SQL engine queries using a visual query designer |
| • | Generate code to automatically create tables and indexes using the Advantage Tables to Code Generator |
Configuration
When setting up your database application ARC enables you to:
| • | Test the client’s environment to prevent problems when connecting to the Advantage Database Server |
| • | Create aliases similar to those used by the Borland Database Engine |
Management
After the database is running, ARC enables you to:
| • | Manage data with functions such as reindexing, packing tables, restructuring and repairing tables |
| • | Manage Data Dictionaries with the Advantage Database Manager Tool |
| • | Manage Advantage Database Server activity with the Advantage Management utility |
| • | Execute maintenance tasks from within a transaction |
