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
 |
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
Allows working with user-defined table types in SQL Server 2008.
|
 |
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
 |
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 2005 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 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.
|
 |
TMSEncryptor
Represents data encryption and decryption in client application.
|
 |
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.
|