• TMSConnection - lets you set up and control connections to SQL Server

•  TMSQuery - queries execution, operates record set, flexible way updating database tables

• TMSTable - lets you retrieve and update data in a single table without writing SQL statements

• TMSStoredProc - executes stored procedures and functions

• TMSSQL - executes SQL statements and stored procedures, which do not return rowsets

• TMSScript - executes sequences of SQL statements

• TMSUpdateSQL - lets you tune update operations for a DataSet component

• TMSDataSource - provides an interface between a SDAC dataset components and data-aware controls on a form

• TMSSQLMonitor - allows to monitor dynamic SQL executing in SDAC based applications

• TMSConnectDialog - allows you to build custom prompts for usernames, passwords, and servers

• TVirtualTable - dataset stores data in memory

• MSDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

• TMSLoader - allows you to quickly load data into SQL Server databases

•  TMSDump - serves to store a database or its parts as a script and also to restore database from received script

• TMSServiceBroker - lets you work with Service Broker technology to send and receive messages

• TMSMetadata - allows to retrieve embracing metadata on specified SQL object

• TMSChangeNotification - lets you react on different server side changes on-the-fly. Based on the Query Notifications mechanism of SQL Server 2005

• TMSTransaction - lets you control distributed transactions via Microsoft Distributed Transaction Coordinator

• TMSCompactConnection - lets you set up and control connections to SQL Server Compact Edition

• TCRBatchMove - transfers data between all types of TDataSet descendants

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)

• VCL, VCL.NET, and CLX versions of library available

• Full support of the latest Microsoft SQL Server versions, including Express and Compact Editions

• Support for all SQL Server data types

•  Disconnected Model with automatic connection control for working with data offline

• Local Failover for detecting connection loss and implicitly reexecuting certain operations

• All types of local sorting and filtering, including by calculated and lookup fields

• Automatic data updating with TMSQuery, TMSTable, and TMSStoredProc components

• Unicode support

• Support for many SQL Server-specific features, such as MARS and bulk copy operations

• Advanced script execution with TMSScript component

• Support for using macros in SQL

• Easy migration from BDE and ADO with Migration Wizard

• Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications

• Includes annual SDAC Subscription with Priority Support

• Licensed royalty-free per developer, per team, or per site

Components
All editions of SDAC include the following basic components:

• TMSConnection - lets you set up and control connections to SQL Server
• TMSQuery - queries execution, operates record set, flexible way updating database tables
• TMSTable - lets you retrieve and update data in a single table without writing SQL statements
• TMSStoredProc - executes stored procedures and functions
• TMSSQL - executes SQL statements and stored procedures, which do not return rowsets
• TMSScript - executes sequences of SQL statements
• TMSUpdateSQL - lets you tune update operations for a DataSet component
• TMSDataSource - provides an interface between a SDAC dataset components and data-aware controls on a form
• TMSSQLMonitor - allows to monitor dynamic SQL executing in SDAC based applications
• TMSConnectDialog - allows you to build custom prompts for usernames, passwords, and servers
• TVirtualTable - dataset stores data in memory
• MSDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

SDAC Professional Edition includes the following additional components:

• TMSLoader - allows you to quickly load data into SQL Server databases
• TMSDump - serves to store a database or its parts as a script and also to restore database from received script
• TMSServiceBroker - lets you work with Service Broker technology to send and receive messages
• TMSMetadata - allows to retrieve embracing metadata on specified SQL object
• TMSChangeNotification - lets you react on different server side changes on-the-fly. Based on the Query Notifications mechanism of SQL Server 2005
• TMSTransaction - lets you control distributed transactions via Microsoft Distributed Transaction Coordinator
• TMSCompactConnection - lets you set up and control connections to SQL Server Compact Edition
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
The following list describes the main features of SQL Server Data Access Components.

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest Microsoft SQL Server versions, including Express and Compact Editions
• Support for all SQL Server data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TMSQuery, TMSTable, and TMSStoredProc components
• Unicode support
• Support for many SQL Server-specific features, such as MARS and bulk copy operations
• Advanced script execution with TMSScript component
• Support for using macros in SQL
• Easy migration from BDE and ADO with Migration Wizard
• Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications
• Includes annual SDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site