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 overall high-performance connectivity to SQL Server.

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 the special SDAC Professional Edition with Source Code. The source codes of DataSet Manager and Migration Wizard are not distributed. The source code of SQL Server Direct Mode is distributed obfuscated.

The matrix below compares features of SDAC editions. The detailed list of all SDAC features you can find at the SDAC Features page .

Features Standard Professional
Direct Connectivity

Direct Connectivity

Connection without SQL Server client No Yes
DAC

Mobile Development

iOS application development No Yes
Android application development No Yes
DAC

Data Access Components

Base 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

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 metainformation about database objects
  TMSMetadata
No Yes
Storing a database as a script
  TMSDump
No Yes
DataBase Activity Monitoring

Database activity monitoring

Monitoring of per-component SQL execution
  TMSSQLMonitor
Yes Yes
Additional Components

Additional Components

Advanced connection dialog
  TMSConnectDialog
Yes Yes
Data encryption and decryption
  TMSEncryptor
No Yes
Data storing in memory table
  TVirtualTable
Yes Yes
Advanced DBGrid with extended functionality
  TCRDBGrid
Yes Yes
Records transferring between datasets
  TCRBatchMove
No Yes
Design-Time Features

Design-Time Features

Enhanced component and property editors Yes Yes
Migration Wizard Yes Yes
DataSet Manager No Yes
Cross IDE Support

Cross IDE Support

Lazarus and Free Pascal support No    Click to view restrictions
Single License Price $149.95 $249.95

1 Available only in editions with source code.