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
|