SDAC

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 features of SDAC editions. See Features for the detailed list of SDAC features.

SDAC Edition Matrix

Feature Standard Professional

Direct connectivity

Connection without SQL Server client No Yes

Desktop Application Development

Windows Yes Yes
macOS No Yes
Linux No Yes

Mobile Application Development

iOS No Yes
Android No Yes

Data Access Components

TMSConnection
TMSQuery
TMSSQL
TMSTable
TMSStoredProc
TMSUpdateSQL
TMSDataSource
Yes Yes
Script executing
TMSScript
Yes Yes
Transactions managing
TMSTransaction
Yes Yes
Fast data loading into the server
TMSLoader
No Yes

SQL Server Specific Components

Working with user-defined table types in SQL Server 2008
TMSTableData
Yes Yes
Connection to SQL Server Compact Edition
TMSCompactConnection
No Yes
Reaction on server side changes on-the-fly
TMSChangeNotification
No Yes
Sending messages with Service Broker system
TMSServiceBroker
No Yes
Obtaining metadata about database objects
TMSMetadata
No Yes
Storing a database as a script
TMSDump
No Yes

DataBase Activity Monitoring

Monitoring of per-component SQL execution
TMSSQLMonitor
Yes Yes

Additional components

Advanced connection dialog
TMSConnectDialog
Yes Yes
Data encryption and decryption
TMSEncryptor
No Yes
Data storing in memory table
TVirtualTable
Yes Yes
Dataset that wraps arbitrary non-tabular data
TVirtualDataSet
Yes Yes
Advanced DBGrid with extended functionality
TCRDBGrid
Yes Yes
Records transferring between datasets
TCRBatchMove
No Yes

Design-Time Features

Enhanced component and property editors Yes Yes
Migration Wizard Yes Yes
DataSet Manager No Yes

Cross IDE Support

Lazarus and Free Pascal Support No Click to view restrictions

1 Available only in Professional Edition with Source Code.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback