KyleCordes.com
Home Articles BDE Alternatives Guide JBuilder Open Tools Services & Training About
Product: Advantage Database Server
Vendor: Extended Systems
Version: 6.2 Data Aware Controls: TDataSet (D3+ C3+)
Web Site: http://www.advantagedatabase.com/ Support Delphi Vers: 3 4 5 6 7
Email: GetAdvantage@extendsys.com Supports C++B Vers: 3 4 5 6
Source Available: Yes Supports Kylix Vers: 1 2 3

Description: Advantage Database Server is a high performance client/server RDBMS for stand-alone, networked, Internet, and mobile database applications. Advantage Database Server allows developers the flexibility to combine powerful SQL statements and relational data access methods with the performance and control of navigational commands. Advantage has native development interfaces designed to leverage existing knowledge of popular development tools. Using optimized data access, Advantage provides security, stability, and data integrity with zero administration.
Deployment: Client/Server: 2 DLLs totalling ~700K. Local Server: 2 DLLs totalling ~1500K. Both: 3 DLLs totalling ~1600K.
Modes of
Operation:

Check indicates
primary intended
use(s).
Local: Yes: Via Advantage Local Server or via Client/Server with client and server running on the same computer
Multiuser File Server: Yes: Via Client/Server or Local Server
Multiuser Client/Server: Yes: Client/Server available for Windows NT/2000, NetWare, Linux and Windows 9x/Me
Web Server: Yes: Internet Connector Licensing also available

Package(s) Available: Price:
Local Server version Free
Client/Server version priced per concurrent user Call for pricing

Database/File Format Supported Native? Via Notes
Proprietary Yes .ADT (tables), .ADM (memos and binary), .ADI (compound index)
FoxPro compatible DBF Yes .DBF (tables), .FPT (memos and binary), .CDX (compound index), .IDX (index)
Clipper compatible DBF Yes .DBF (tables), .DBT (memos and binary), .NTX (index)

Third Party Tool Compatibility: Compatible?
(Delphi) Database Explorer Yes
Ace Reporter Yes
InfoPower Yes
Orpheus (TurboPower) Yes
QuickReports Yes
RAVE Reports Yes
ReportBuilder Pro Yes

Vendor's Description (from Readme files, web site, etc.):

Advantage Database Server is a high performance client/server RDBMS for stand-alone, networked, Internet, and mobile database applications. Advantage Database Server allows developers the flexibility to combine powerful SQL statements and relational data access methods with the performance and control of navigational commands. Advantage has native development interfaces designed to leverage existing knowledge of popular development tools. Using optimized data access, Advantage provides security, stability, and data integrity with zero administration.
With no mandatory configuration requirements, Advantage is easily installed on the existing network infrastructure. Because of the embedded qualities of Advantage, it works tirelessly behind the application, delivering client/server performance, stability, and data integrity that today's business applications demand.
The Advantage Database Server won the 2003 Delphi Informent Magazine's Reader's Choice Award for "Best Database Connectivity" and Advantage Database Server was runner-up for "Best Database Engine". Advantage also won the 2002 and 2001 Delphi Informant Magazine's Reader's Choice Award for "Best Database Engine" and was runner-up for "Product of the Year".

Some of the many features available in the Advantage Database Server includes:

  • Complete referential integrity support including primary/foreign key definition and cascaded updates and deletes
  • Full server-based transaction processing eliminates database corruption, drastically reducing support costs
  • Database security and encryption support
  • Centralized, server-based control of database means database and index corruption is eliminated
  • Support for Stored Procedures via Advantage Extended Procedures
  • Advanced query and filter optimization via Advantage Optimized Filter functionality
  • SQL engine supports much of the SQL-92 standard
  • Data validation via record-level and field-level constraints
  • Server-to-server and server-to-desktop/laptop replication functionality available
  • Provides flexibility of data access via native relational SQL or direct navigational database commands
  • Eliminates the need for the BDE and dbExpress for easy development and deployment
  • Features native components parallel to TTable, TQuery, and TStoredProc
  • Provides access to advanced functionality not found in native Delphi database components
  • Easy conversion from Paradox, InterBase, Access, Pervasive and SQL Server files using Advantage Data Architect
  • TDataSet Descendant source code included
  • Low maintenance -- no database administrator required
  • Fully scalable from local, to peer-to-peer, to client/server environments -- with one set of source code
  • Fast and easy to install using existing network file system and hardware

BDE Alternatives Guide Comments:

Advantage can be used instead of the more commonly considered client/server databases: MS SQL Server, Oracle, etc. Advantage offers client/server performance and reliability at a very low price, compared with the big-name database servers. Also, it provides extremely easy scalability from single-user to client/server deployment.

I regularly receive feedback from satisfied Advantage users. Perhaps this is related to Advantage's intensive QA and regression test suite.



Is this data old or incomplete? Visit the How To Contribute page. You will also need to download the XML version of the data on this page here. Note that you need to right-click and download the file, not view it in your browser.


Visit the new BAG: bdalternatives.com

Introduction

The List

By Category

By DB Server /
File Type

Why Not
the BDE?

How to Choose

Multi-Tier
Development

Pricing

BAG FAQs



kylecordes.com, Copyright 1999-2007 Kyle Cordes - Contact Kyle