SDAC Component List

Basic SDAC components are included in all SDAC editions. There are additional components in SDAC Professional Edition. The Editions page gives full description of features and included components of each edition.

Basic SDAC components

MSConnection

TMSConnection
Lets you set up and control connections to SQL Server.

MSQuery

TMSQuery
Uses SQL statements to retrieve data from SQL Server table or tables and supply it to one or more data-aware components through a TDataSource component. Provides flexible update of data.

MSTable

TMSTable
Lets you retrieve and update data in a single table without writing SQL statements.

MSStoredProc

TMSStoredProc
Executes stored procedures and functions.

MSSQL

TMSSQL
Executes SQL statements and stored procedures that do not return rowsets.

MSScript

TMSScript
Executes sequences of SQL statements.

MSUpdateSQL

TMSUpdateSQL
Lets you tune update operations for DataSet component.

MSDataSource

TMSDataSource
Provides an interface between a SDAC dataset components and data-aware controls on a form.

MSSQLMonitor

TMSSQLMonitor
Interface for monitoring dynamic SQL execution in SDAC-based applications.

MSConnectDialog

TMSConnectDialog
Is used on client side to supply username, password, database and server name.

MSTableData

TMSTableData
Allows working with user-defined table types in SQL Server 2008.

VirtualTable

TVirtualTable
Provides dataset functionality for data that has no real database connection. This component is placed on the Data Access page of the Component palette, not on the SQL Server Access page.

SDAC Professional Edition components

MSLoader

TMSLoader
Provides quick data loading to SQL Server database.

MSDump

TMSDump
Serves to store a database or its parts as a script and also to restore database from received script.

MSServiceBroker

TMSServiceBroker
Lets you send and receive messages using the SQL Server 2005 Service Broker system.

MSMetaData

TMSMetaData
Retrieves embracing metadata on specified SQL object.

MSChangeNotification

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

MSTransaction

TMSTransaction
Lets you control distributed transactions via Microsoft Distributed Transaction Coordinator.

MSCompactConnection

TMSCompactConnection
Lets you set up and control connections to SQL Server Compact Edition.

MSEncryptor

TMSEncryptor
Represents data encryption and decryption in client application.

CRBatchMove

TCRBatchMove
Transfers data between all types of TDataSets descendants. This component is placed on the Data Access page of the Component palette, not on the SQL Server Access page.