| SQL Server Data Access Components Features |
- General usability
- Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
- Interface compatible with standard data access methods, such as BDE and ADO
- VCL and VCL for .NET versions of library available
- Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
- Unicode support
- Network and connectivity
- Disconnected Model with automatic connection control for working with data offline
- Local Failover for detecting connection loss and implicitly reexecuting certain operations
- Connection string support
- Ability to search for installed SQL Server databases in a local network
- Support for connection encryption without certificate validation [New]
- Compatibility
- Full support of the latest Microsoft SQL Server versions, including Express and Compact editions
- Support for all SQL Server data types
- Compatible with all IDE versions starting with Delphi 5 and C++Builder 5
- Wide reporting component support, including support for InfoPower, ReportBuilder, and FastReport
- Wide support of all standard Borland and third-party visual data-aware controls
- Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications
- SQL Server technology support
- TMSLoader component for improving record insertion performance
- TMSServiceBroker component for SQL Server 2005 queuing and reliable messaging
- Enhanced support for User-defined Types of SQL Server [New]
- Enhanced support for SQL Server Compact Edition with the TMSCompactConnection component [New]
- Possibility to change application name for a connection
- Possibility to change workstation identifier for a connection
- Configuration of OEM/ANSI character translation
- Ability to lock records and tables [New]
- Performance
- High overall performance
- Fast controlled fetch of large data blocks
- Optimized string data storing
- Advanced connection pooling
- High performance of applying updates in CachedUpdates mode
- Caching of calculated and lookup fields
- Fast Locate in a sorted DataSet
- Preparing of user-defined update statements
- Local data storage operations
- Database-independent data storage with TVirtualTable component
- CachedUpdates operation mode
- Local sorting and filtering, including by calculated and lookup fields
- Local master/detail relationship
- Master/detail relationship in CachedUpdates mode
- Data access and data management automation
- Automatic data updating with TMSQuery, TMSTable and TMSStoredProc components
- Support for Query Notifications with the TMSChangeNotification component [New]
- Automatic record refreshing
- Automatic query preparing
- Support for getting results from queries with the FOR XML clause in readable view [New]
- Support for ftWideMemo field type in Delphi 2006 and higher
- Extended data access functionality
- Separate component for executing SQL statements
- Simplified access to table data with TMSTable component
- Ability to retrieve metadata information with TMSMetaData component [Improved]
- BLOB compression support
- Support for using macros in SQL
- FmtBCD fields support
- NonBlocking mode allows background executing and fetching data in separate threads
- Ability to customize update commands by attaching external components to TMSUpdateSQL objects.
- Deferred detail DataSet refresh in master/detail relationships
- MIDAS technology support
- MSDataAdapter component for WinForms and ASP.NET applications.
- Distributed transactions support with the TMSTransaction component [New]
- Data exchange
- Transferring data between all types of TDataSet descendants with TCRBatchMove component
- Data export and import to/from XML (ADO format)
- Ability to synchronize positions in different DataSets
- Script execution
- Advanced script execution features with TMSScript component
- Support for executing individual statements in scripts
- Support for executing huge scripts stored in files with dynamic loading
- Optimized multi-statement script execution
- SQL Execution monitoring
- Extended SQL tracing capabilities provided by TMSSQLMonitor component and DBMonitor
- Borland SQL Monitor support
- Ability to send messages to DBMonitor from any point in your program
- Visual extensions
- Includes source code of enhanced TCRDBGrid data-aware grid control
- Customizable connection dialog
- Cursor changes during non-blocking execution
- Design-time enhancements
- DataSet Manager tool to control DataSet instances in the project
- Advanced design-time component and property editors
- Automatic design-time component linking
- Easy migration from BDE and ADO with Migration Wizard
- More convenient data source setup with the TMSDataSource component
- Syntax highlighting in design-time editors
- Product clarity
- Complete documentation sets
- Printable documentation in PDF format
- A large amount of helpful demo projects
- Error handling
- Multiple error processing support
- Unicode error messages support
- Licensing and support
- Included annual SDAC Subscription with Priority Support
- Licensed royalty-free per developer, per team, or per site
| |
|
