|
|
|
DTM Schema Comparer, features list
Environment
| Operating systems support |
Windows XP, Vista, 7, Server 2003, 2008. |
| Additional client side software required |
ODBC 32, IDAPI (BDE), OLE DB or Oracle Call Interface. |
| Does the product support any DBMS-specific features? |
Yes, for MS SQL Server, Oracle, DB2, Sybase and Interbase/Firebird. |
Software product
| What versions of the tool are available? |
Standard and professional. |
| Does the product support command line mode? |
Yes, professional version only. |
| Does the schema comparison tool allow to execute custom SQL scripts against connected databases? |
Yes, the program has built in SQL console. |
| Can the tool compare or syncronize databases in unattended mode? |
Yes, for professional version only. |
| Can a comparision or synchronization process be scheduled? |
Yes, the tool is compatible with Windows Schedule System. |
| Does the comparer support object list filtering? |
Yes, "exclude" and "include" by mask filters are available. |
Comparison and Synchronization Processes
| Can the program compare different database types? |
Yes, except DBMS specific objects. |
| Can the program synchronize different database types? |
Yes, in case both databases support ANSI SQL. |
| Can the program generate SQL script instead of actually synchronization? |
Yes. |
| Can the program produce comparison report? |
Yes, with three levels of detalization (HTML format). |
| What kind of table properties can be compared? |
Name, columns, comment, primary key, indexes, triggers and relationships. |
| What kind of column properties can be compared? |
Name, data type, size, decimal places, null/not null property, default value, comment, check constraints. |
Assistance/Help
| Is help for the tool built into the product? |
Yes. |
| Is help for the tool available online? |
Yes, see online help |
|
|
|
• On-line