Background
Here I am having used SQL Server Management Studio ( SSMS ) for so long, I am satisfied.
It’s GUI is versely superior to SQL 2000 Query Analyzer and it exposes just about every SQL Functionality that I use on daily basis.
Stumped
Spent hours trying to capture a query’s grid display unto Excel, but Excel column size was getting in the way.
And, so googled for ways to display columns as rows.
DBeaver
Googled and found DBeaver.
The nice thing about it is that I can export queries result set into XML or HTML.
Download
DBeaver is available here.
Export Query
Screen Shot
Data Transfer Target Type and Format
Image
Data Transfer – Extraction Settings
Image
Data Transfer – Settings – See export settings
Image
Data Transfer – Output – Configure export output parameters
Image
Data Transfer – Confirm – Check results
Image
Sample Files
HTML
XML
Other Functionalities
Database Diagram
Database Modeling is also easy and nice.
Table Structure
Properties
References
DDL
Data
Database Supported
DBeaver supports both SQL and NoSQL Databases.
For SQL databases, it relies on JDBC.