ElevateDB

Key Features

• Transparent Local and Client-Server Access - Local and client-server access is identical in operation, requiring only a few property modifications to switch between the two.
• Replication - Complete replication support is included, and replication can be set up in any configuration desired - uni-directional, bi-directional, push, pull, merge, and snapshot (using backup facilities).
• Small Footprint - Client access code added to a compiled application is minimal, and the ElevateDB Server is less than 2 Mb in size.
• Multi-threaded - Both local and client-server sessions can be multi-threaded in an application.
• Stored Procedures and Functions - Full SQL/PSM support for stored procedures and functions, including dynamic and DDL statements, structured exception handling, and rich cursor handling
• Full text indexing - Any CHAR, VARCHAR, or CLOB column can be indexed by word and searched using CONTAINS operator, and text to be indexed can be filtered according to another type column in the table
• Excellent performance - All SQL queries are optimised using available indexes, expression reduction, and I/O cost optimisation, and query plans can be generated to show how a query was optimized and executed
• Support for Triggers and Views
• Managed and Native Code Compilation - ElevateDB does not use any direct pointer access or memory manipulation when running under .NET (VCL.NET support or ADO.NET data provider), making it 100% managed code in that environment, while it also provides 100% native code compilation with Win32 compilers
• ANSI/Unicode - ElevateDB is available in ANSI (8-bit encoding using the Windows ANSI code pages) or Unicode (16-bit UTF-16 encoding) versions