DbVisualizer 9.1.3 Build 2091 Demo

Written by Admin on. Posted in Software

DbVisualizer 9.1.3 Build 2091 Demo

A database tool useful for developers and database administrators to aid maintaining their databases

DbVisualizer is a comprehensive application that will enable developers and database administrators to manage their databases. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.
Here are some key features of “DbVisualizer”:
  • Supports multiple simultaneous database connections
  • Connect to a database with a single click
  • Database objects explorer
  • View information for: tables, indexes, primary keys, privileges, schemas, databases, procedures and a lot more
  • View referential integrity rules in a graph or list
  • Organize database connections in folders
  • Database objects filtering
  • Search database objects
  • Drag objects to any field including the editor
  • Export results CSV HTML XLS
  • Create and Alter table
  • Table data editing in spreadsheet like editor
  • Persistent table data filters
  • Quick filtering in grids
  • Display references to other tables
  • Monitor row count differences
  • Support for BLOB, CLOB and binary data
  • View BMP, TIFF, PNG, GIF and JPEG images
  • View XML data in tree or text format
  • Import table data from CSV files
  • Syntax colored SQL editor
  • Auto Completion (aka code completion, intellisense)
  • Support for multiple SQL editors
  • Support for multiple result sets SQL’s
  • SQL editors displayed as tabs or windows
  • Result sets displayed as tabs or windows
  • Support for procedures producing multiple result sets
  • SQL formatter with extensive customization options
  • Execution control (stop on error/warning)
  • View result sets as grid, text or chart Grid, Text, Chart, Grid
  • Editable result sets with the inline or form editors
  • Support for BLOB, CLOB and binary data
  • View BMP, TIFF, PNG, GIF and JPEG images
  • View XML data in tree or text format
  • Export result sets with Create Table option CSV HTML XLS XML SQL TEXT CSV HTML
  • Batch execution enabling export of large result sets
  • SQL history saved between sessions
  • Advanced SQL bookmark functionality
  • Sort by clicking column header
  • Simple calculations on data
  • Parameterized SQL queries
  • Drop objects dragged from the Objects Tree
  • Support for execution of selected SQL statements
  • Execute SQL statement at cursor position
  • SQL execution logging with filtering options
  • Support for creating multi SQL select scripts
  • Pre-defined key maps
  • Oracle, DB2 and SQL Server: Explain plan support
  • Oracle: Support for the XML data type
  • Oracle: Support for DBMS_OUTPUT
  • Design queries with a few mouse clicks
  • No SQL expertise is required
  • Adopts the generated SQL for the actual database
  • Reverse engineer a SELECT statement
  • Auto Join of columns by primary/foreign key or name
  • Graph or list of referential integry rules
  • Several automatic graph layout managers
  • Connect tables by respective column(s)
  • Bridge link support
  • Graph zooming, fit, animation and navigator pane
  • Export and print
  • Save/Load manual layouts
  • Expose foreign keys by data selection
  • Limit referenced data with filters
  • Tag support
  • Extensive collection of tool properties
  • Configurable key bindings with pre-defined key maps
  • Customize the format of Date, Time and Numbers
  • Look & Feels for Windows, Mac, UNIX, cross platform
  • Set fonts
  • Set unique properties per database connection
  • Permissions checks what commands need confirmation
  • Instant Monitor of results from SQL queries
  • Automatic monitoring of any result set SQL
  • View data in grid, text or professional charts Grid, Text, Chart Grid
  • Print and export monitored data
  • Export any result set CSV HTML XLS
  • Test data generator
  • Table Data Import wizard
  • Dynamic JDBC driver management
  • Bundled JDBC drivers for: DB2 for Windows/Linux, JavaDB/Derby, Mimer, MySQL, PostgreSQL, SQL Server, Sybase ASA, Sybase ASE
  • Grid support: sorting, auto fit, column layout, resizing
  • The following features are disabled:
  • Edit Table Data
  • Auto Completion support in the SQL editor
  • Visual Create/Alter Table support
  • Execution of multi statement SQL scripts
  • Charting of data
  • Management of BLOB/CLOB data
  • Export Schema/Database
  • Import data from CSV files
  • Query Builder
  • Foreign Key Data Navigator
  • Explain plan support
  • Management of views, triggers, summary tables, synonyms, functions, procedures, system tables, triggers, columns primary keys, privileges, constraints, references, DDL, program, modules, data files, table spaces, etc.
What’s New
  • Enhancement:
  • Check for Update: Show underlying error message when not being able to connect
  • Data tab: Should be possible to assign key binding to the “Show in Navigator” action in the Data tab
  • General: Show underlying error message when not being able to connect for Pro evaluation
  • General: It should be possible to modify vmoptions per user and not only for the installation which may be shared by many users
  • Import: Dropping a file on a Tables or Table object should open the Table Data Import feature
  • Installation/Update Installation: Changes in the vmoptions file should survive when installing new versions
  • Workspace: Add option to set that “Open in Tab” should switch to the already open object tab first, otherwise open a new tab
  • Bug:
  • Check for Update: Use System Proxy Settings does not work on Windows if an automatic configuration script is used for system setting
  • Connection Setup: Disconnect All may take a while if having a lot (100+) of database connections
  • DB Support: Oracle: Max S…

Tags: ,

Trackback from your site.

Leave a comment