PLEASE NOTE: Our Web site uses cookies to help improve your browsing experience while here and to provide us with information on how you use our site. Click here to see the cookies we use. Click here to learn how to delete and block cookies (if you block cookies, parts of our Web site will not work). If you do not modify your cookie settings, then we take that to mean you are happy with the default and that you are explicitly consenting to our use of the cookies as described.

Check the box to close this pop-up.

Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow
Products > Database Management > Advantage Database Server > Advantage Data Architect Utility

Advantage Data Architect Utility


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:


  • 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


  • 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


  • 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


Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics
© Copyright 2014, Sybase Inc. - v 7.6