SQL Server Data Access Components Editions
SQL Server Data Access Components comes in two editions: Standard and Professional.
The Standard edition includes the SDAC basic connectivity components and SDAC Migration Wizard. SDAC Standard Edition is a cost-effective solution for database application developers who are looking for high-performance connectivity to SQL Server for secure, reliable, and high-speed data transmission.
The Professional edition shows off the full power of SDAC, enhancing SDAC Standard Edition with support for SQL Server-specific functionality, access to the Direct mode for connecting to the SQL Server directly via TCP/IP, and advanced dataset management features.
You can get Source Access to the implementation of all the component classes in SDAC by purchasing a special SDAC Professional Edition with Source Code, which includes the source code of all component classes. The source code of DataSet Manager and Migration Wizard is not distributed. The source code of the Direct mode for SQL Server is distributed obfuscated.
The matrix below compares the features of SDAC editions. The detailed list of all SDAC features can be found on the features page.
| Features | Standard | Professional | |
|---|---|---|---|
Direct Connectivity |
|||
| Connection without SQL Server client |
|
|
|
Desktop Application Development |
|||
| Windows |
|
|
|
| macOS |
|
|
|
| Linux |
|
|
|
Mobile Application Development |
|||
| iOS |
|
|
|
| Android |
|
|
|
Data Access Components |
|||
|
Base components TMSConnection TMSQuery TMSSQL TMSTable TMSStoredProc TMSUpdateSQL TMSDataSource |
|
|
|
|
Script executing TMSScript |
|
|
|
|
Transactions managing
TMSTransaction |
|
|
|
|
Fast data loading into the server
TMSLoader |
|
|
|
SQL Server Specific Components |
|||
|
Working with user-defined table types in SQL Server 2008 TMSTableData |
|
|
|
|
Connection to SQL Server Compact Edition TMSCompactConnection |
|
|
|
|
Reaction on server side changes on-the-fly TMSChangeNotification |
|
|
|
|
Sending messages with Service Broker system TMSServiceBroker |
|
|
|
|
Obtaining metadata about database objects TMSMetadata |
|
|
|
|
Storing a database as a script TMSDump |
|
|
|
Database activity monitoring |
|||
|
Monitoring of per-component SQL execution TMSSQLMonitor |
|
|
|
Additional Components |
|||
|
Advanced connection dialog TMSConnectDialog |
|
|
|
|
Data encryption and decryption TMSEncryptor |
|
|
|
|
Data storing in memory table TVirtualTable |
|
|
|
|
Dataset that wraps arbitrary non-tabular data TVirtualDataSet |
|
|
|
|
Advanced DBGrid with extended functionality TCRDBGrid |
|
|
|
|
Records transferring between datasets TCRBatchMove |
|
|
|
Design-Time Features |
|||
| Enhanced component and property editors |
|
|
|
| Migration Wizard |
|
|
|
| DataSet Manager |
|
|
|
Cross IDE Support |
|||
| Lazarus and Free Pascal support |
|
|
|
| Single License Price | $209.95 | $329.95 | |
1 Available only in editions with source code.