Component List

This topic presents a brief description of the components included in the SQL Server Data Access Components library. Click on the name of each component for more information. These components are added to the SDAC page of the Component palette except for TCRBatchMove and TVirtualTable components. TCRBatchMove and TVirtualTable components are added to the Data Access page of the Component palette. Basic SDAC components are included in all SDAC editions. SDAC Professional Edition components are not included in SDAC Standard Edition.

Basic SDAC components

	TMSConnection	Lets you set up and control connections to SQL Server.
	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.
	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 that do not return rowsets.
	TMSScript	Executes sequences of SQL statements.
	TMSUpdateSQL	Lets you tune update operations for DataSet component.
	TMSDataSource	Provides an interface between a SDAC dataset components and data-aware controls on a form.
	TMSSQLMonitor	Interface for monitoring dynamic SQL execution in SDAC-based applications.
	TMSConnectDialog	Is used on client side to supply username, password, database and server name.
	TMSTableData	Is used for working with user-defined table types in SQL Server 2008.
	TVirtualTable	Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette.
	TVirtualDataSet	Dataset that processes arbitrary non-tabular data.

SDAC Professional Edition components

	TMSEncryptor	Represents data encryption and decryption in client application.
	TMSLoader	Provides quick data loading to SQL Server database.
	TMSDump	Serves to store a database or its parts as a script and also to restore database from received script.
	TMSServiceBroker	Lets you send and receive messages using the SQL Server Service Broker system.
	TMSMetaData	Retrieves 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.
	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 TDataSets descendants. This component is placed on the Data Access page of the Component palette.