|
|
|
DTM Data Comparer, features list
Environment
| Operating systems support |
Windows XP, Vista, 7, Server 2003 or 2008.
For Windows NT (without modern IE) MFC library update required. |
| Additional client side software required |
ODBC, OLE DB, IDAPI (BDE) or Oracle Call Interface. |
| Does the product support any DBMS-specific features? |
Yes, for MS SQL Server, Oracle,
DB2, Sybase and Interbase/Firebird. |
| Can I compare desktop databases or spreadsheets like Access or Excel with this tool? |
Yes. |
| Does the comparison tool allow to execute custom SQL scripts against connected databases? |
Yes, the program has built in SQL console. |
Comparison process
| Can I see only different records in data grid? |
Yes, "Show different only" switches on or off corresponding mode. |
| Can I compare only required columns? |
Yes, mapping feature allows you to do that. |
| Can I compare tables without primary key? |
Yes, the user can specify unique key columns manually. |
| Does the product support complete large binary objects comparison feature? |
Yes. |
| Can the tool remove non significant symbols from values before comparison? |
Yes. |
| Does DTM Data Comparer support comparison for three or more table pairs simultaneity? |
Yes, with "database mode". |
| Can the software compare and/or synchronize data in unattended mode? |
Yes, console mode is available. |
| Can the data comparison tool help me to compare only part of table? |
Yes, you can specify WHERE clause to limit rows to be compared. |
| Can the comparison or synchronization process be scheduled? |
Yes, the data comparison tool is compatible with Windows Schedule System. |
| Can the program generate comparison report? |
Yes, HTML format. |
Synchronization
| Can the product save synchronization script to SQL file? |
Yes. Sample synchronization script. |
| Can the comparison software produce synchronization script without actual synchronization? |
Yes. |
| Can I manage transaction size for synchronization process? |
Yes. |
| Does the comparer support custom SQL statement separators for synchronization script? |
Yes. |
| Can the synchronization tool to generate new script daily? |
Yes, use $DATE$ and $TIME$ macros in the script name. |
| Does the product support selective execution of the synchronization script? |
Yes. |
| Can DTM Data Comparer add COMMIT statement to synchronization script? |
Yes. |
| Does the product support large binary object synchronization? |
No, comparison only. |
| Does the product support data conversion in the syncronization process? |
Yes, read more... |
| Can I block target database rows removing during synchronization process? |
Yes, as well as updating and inserting. |
| Does the product support identity and autoincrement columns? |
Yes, for Microsoft SQL Server and Microsoft Access only. |
Assistance/Help
| Is help for the tool built into the product? |
Yes. |
| Is help for the tool available online? |
Yes, see online help |
See also
|
|
|
|
|
See also
|
|
Articles
|
|
|
|
Related Products
|
|
|
|
|
|
|
|
|
|
|
|
• On-line