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.
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.
Googled and found DBeaver.
The nice thing about it is that I can export queries result set into XML or HTML.
DBeaver is available here.
Data Transfer Target Type and Format
Data Transfer – Extraction Settings
Data Transfer – Settings – See export settings
Data Transfer – Output – Configure export output parameters
Data Transfer – Confirm – Check results
Database Modeling is also easy and nice.
DBeaver supports both SQL and NoSQL Databases.
For SQL databases, it relies on JDBC.