Database Schema Browser Features

Environment

Operating systems support Windows XP, Vista, 7, Windows 8/10 (desktop), Server 2008, 2012.
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, IDAPI 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 newer 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.
Does schema comparison and synchronization features built into the product? No, see DTM Schema Comparer
Is a schema reporting tool built into the product? No, see DTM Schema Reporter
Can I copy database schema with DTM Schema Inspector? No, see DTM Migration Kit

Assistance/Help

Is help for the tool built into the product? Yes.
Is help for the tool available on-line? Yes, see on-line help

See Also

  See Also
Press Releases
 Related Tools
Schema Documenting Tool