Viewing and navigating large scale database schemas often turns out to be a time consuming affair for database administrators. Well, all the time and efforts could be saved by taking some smart assistance for the purpose. One such handy application that could help you dealing with database schemas effectively is DTM Schema Inspector. The utility enables users to work with several database schemas simultaneously, while displaying information in tree-view form. It also supports viewing database properties and content, along with Database schema snapshots allowing users to browse through old states of the database objects. It even consists of effective search tool facilitating navigation for huge number of schemas, and also allows enabling/disabling triggers feature for Oracle and MS SQL.
With the DTM Schema Inspector 1.20.01 application you’re presented with a decently structured console with various required options placed neatly on it. The left pane is assigned to display schema tree-view and the right pane shows different tabs; Text, Properties, Data, Permissions, and Operations. For beginning to browse the database schema, firstly you would require connecting to database by specifying the different Connection Profiles, and select the Connection Type to be ‘Connections to most popular databases’, ‘Connections to Desktop data formats’, ‘Connections to existing and configured data sources’, ‘Connections to existing and configured file DSN’, and ‘Connections using OLD DB providers’. Test the selected connection and press Connect to access the database. The schemas of the database get placed in left pane, from where the related data and its attributes are shown in workspace placed at the right. You can create snapshots that help you in browsing the database objects. The program further comprises of features to export schema into text, XML HTML, or Microsoft Excel format files and SQL window to execute SQL statements. In addition, it also create log file to keep activity record and change the program settings, if required.
DTM Schema Inspector facilitates you to conveniently browse through the metadata and import or export data according to your requirement. The tool is comes loaded with extensive features embedded in a modestly designed console that gives credible performance, making it worthy of 3.5 rating points.