dbPortal is a Windows SQL client that utilises JDBC (Java Database Connectivity) to access relational databases. It is a very useful analytical tool for making sense of your relational data. There are many very useful and time saving features that will make your life easier. dbPortal is the ideal tool for quick and easy access to your data.
It has a relatively small footprint for the functionality it provides and installing it is quick and easy. And because it uses JDBC, you can access any database that provides a compliant driver.
Some of our beta testers use it to work with both Oracle and DB2 at the same site. You have access to your data without having to learn the nuances of how each vendor's toolset works.
Here are some key features of "dbPortal":
· Schema Browser
· Table Browser
· Table Filters with ORDER BY and WHERE
· Ad-hoc SQL queries
· Syntax Highlighting in SQL editor [*New* Support for driver specific keywords]
· Code completion on Table and Column names
· Facility to store Favourites
· JDBC Driver information page
· Export/Import BLOBs to/from file
· Export data to CSV file
· Copy cell(s) and row(s) to the Clipboard [*New* Copy table data as INSERT statements]
· Define virtual Primary Keys
· Define table Aliases
· Run SQL scripts with configurable statement delimiter
· Comments in SQL removed before execution
· Prompt for parameters ${parametername} before SQL execution
· Lock Results so that you can refer to previous results and even re-execute the SQL to monitor changes
Requirements:
· Sun's Java Runtime Environment:
· Approximately 5 Mb free disck space
· JDBC Drivers for target databases
· firebird 1.5 or newer
Limitations:
· nag screen
What's New in This Release: [ read full changelog ]
· Integrated Blob editing (as Text)
· Database Search functionality (find all tables that contain a value)
· Create and Drop Indexes
· Table and View (if supported) DDL export as script
· Client-side "Find" function
· Relationship Editor and Navigator. Explore your data by setting up and following Related data
· Import / Export data to file for backup / restore.