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 features of SDAC editions. See Features for the detailed list of SDAC features.
Feature | Standard | Professional | |
---|---|---|---|
Direct connectivity |
|||
Connection without SQL Server client | |||
Desktop Application Development |
|||
Windows | |||
macOS | |||
Linux | |||
Mobile Application Development |
|||
iOS | |||
Android | |||
Data Access 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 |
1 Available only in Professional Edition with Source Code.