Advantage Data Architect Utility: A complete data management system for Advantage developers
Advantage Data Architect assists in designing, creating and maintaining the database layer of a developer's applications. This also includes Advantage Local Server, which allows for royalty-free distribution for shared and local environments.
The following features are available with the Advantage Data Architect:
Development
- Import and convert other table types (such as Paradox, dBASE, Access, Btrieve, Pervasive and MS SQL Server) to Advantage compatible tables
- Create and maintain Advantage data dictionaries and define referential integrity rules, record and field level constraints, and more
- Create tables and indexes
- Restructure existing tables
- Encrypt/decrypt tables and dictionaries
- 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
- Check the client workstation's environment to test and diagnose connection issues with the Advantage Database Server
- Setup Access Control Lists to define user access rights for users who wish to connect to the Advantage Database Server
- Create aliases similar to those used by the Borland Database Engine
Management
- Manage the database with functionality for rebuilding indexes and packing, restructuring and repairing tables
- Manage Advantage data dictionaries with the Advantage Data Dictionary Manager
- Observe Advantage Database Server activity with the Advantage Management utility
- Execute maintenance tasks from within a transaction
- Compare data dictionaries via the dictionary differentiation tool
Downloads
