Table Data Comparer Description |
||
| ||
|
Features | Detailed Description The TableDataComparer is used for comparing and synchronizing data between database tables. It can synchronize records within the tables between two different databases. This component works with all databases supported by DBC VCL and capable of synchronizing of data between databases of different type (e.g. MS SQL and Oracle). TableDataComparer uses the TDBCConnectionXXX connection components to connect to databases. TableDataComparer creates the resulting update script which contains INSERT, UPDATE and DELETE statements which will alter the Target database table to make it identical to Master database tables. This resulting update script can be saved into a file and later executed against the Target database using standard SQL console for given database or executed via TxxxSQLExec component (where xxx will be different for given databases). TableDataComparer has wide set of options, properties and events which make possible replication of data between tables with different structures. E.g. if tables have different fields, you can manually set-up list fields used for comparison and fields mapping. Any SQL-statement which returns a set of records can be used for data comparison and replication. It can be complex SQL statement with multiple joins and sub-selects or view or just a record-set returned by stored procedure and so on. Use the SelectSQL property or OnGetSelectSQL event to set-up the desired SQL statements. TableDataComparer also gives you the control over the Insert/Update/Delete operations. So you can create a script which will add or update records without deleting old records. Please see the Demos code (TableDataComparer) and also the indexed Help documentation provided with the Database Comparer VCL installation for more details about using this component. Property List
Method List
Event List
|
Name
Description
AllowedOperations