The Advantage Data Architect (ARC) is a tool designed to assist in developing and maintaining Advantage database applications.
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 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 using the Advantage Environment Check Utility 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 |
| • | Manage Advantage Database Server activity with the Advantage Management utility |
| • | Execute maintenance tasks from within a transaction |
Linux Operating System:
ARC support for the Linux operating system was dropped after the 7.1 release. If you need to use ARC on a Linux client you can download version 7.1 from the Advantage Developer's Zone. This help file does not cover ARC 7.1.