|
|
|
DTM Schema Inspector, features list
Environment
| Operating systems support |
Windows XP, Vista, 7, Server 2003, 2008. |
| Additional client side software required |
ODBC, OLE DB, IDAPI or Oracle Call Interface. |
| What kind of unified database interfaces are supported? |
ODBC (32 bit), OLE DB or Oracle Call Interface. |
| Does the schema browser support desktop database formats? |
Yes: Access, DBF, Excel, Paradox. |
| Does the product support any DBMS-specific features? |
Yes, for Microsoft SQL Server, Oracle, DB2, Sybase, MySQL, PostgreSQL and Interbase/Firebird. |
| Does the schema tool support Express edition of the SQL Server? |
Yes, for 2005 and 2008 versions. |
Functions and Features
| Can the software product operate with all MS SQL Server databases for connected instance? |
Yes. The user should keep database name empty in the Connect Window for this mode. |
| How many connection can be established simultaneous? |
Up to 40-60 connections depends on available resources, database systems and driver versions. |
| Does the schema tool allow to execute custom SQL scripts against connected database? |
Yes, the program has built in SQL console. |
Database Schema management
| Is a database schema viewer built into the product? |
Yes |
| What kind of operations offers this management tool for database objects? |
Drop, rename and execute depends on object type. |
| Does the schema tool support schema snapshots? |
Yes. |
| Does the schema inspector support search feature? |
Yes. |
| Does the program support database schema filtering feature? |
Yes. |
| Is an export schema tool built into the product? |
Yes, to SQL script. |
| Is a compare and synchronization schema tool built into the product? |
No, see DTM Schema Comparer |
| Is a schema reporting tool built into the product? |
No, see DTM Schema Reporter |
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