SqlDbx is a fast and easy to use database SQL development IDE for database administrators, application and database developers working in heterogeneous database environments.

product

SqlDbx is built around an advanced SQL Editor and Database Object Explorer. SqlDbx provides a consistent user interface between different DBMS Systems. The intuitive and straightforward interface allows developers to improve their productivity by having easy access to commonly used features. Run queries, execute scripts, and browse database objects without ever leaving the editor window. SqlDbx is a standalone executable file, requiring no installation, leaving the user's computer unmodified.

Features:

  • High performance native support for major Database Servers including Microsoft, Sybase ASE, Oracle, IBM DB2 zOS/iSeries/LUW, Informix, PostgreSQL, Teradata, MySQL
  • Browse and Explore Servers
  • Fast, intelligent, extensive and highly customizable Intellisense
  • Advanced Script Editor with Syntax highlighting, Auto Complete, Speed Typing, Script Variables, Drag/Drop, Column (Block) Mode
  • Automatically highlight matching parenthesis for BEGIN/END, IF/END IF, CASE/END, ... SQL blocks
  • Full Unicode support
  • x86 and x64 Versions
  • Visual Schema and Data Diff, File Diff, Quick Diff
  • SQL Object Scripting
  • SQL Formatter and Beautifier
  • Generate SELECT, INSERT, UPDATE, DELETE, CREATE, WHERE IN data modification statements directly from Result Grid
  • SQL Templates with support for formal parameters
  • Parameterized Queries and substitution variables
  • Import / Export to CSV, XML, Excel
  • Schema Object browser
  • SQL statement execution history
  • Favorite objects. Find object
  • Search in Database and in Result Grid
  • Directly edit table data in Result Grid
  • Group, total, sort, filter, format, retrieve parent and child data rows, export and transpose data in Result Grid
  • Execute procedures and functions with automatic argument specification
  • Graphic Query Execution Plan and Query Statistics
  • Administrative Views
  • Portable mode
  • Localized in 10 languages
  • Simple deployment. No dll's or other dependencies. Just one executable (2.0 meg.)

Product

Supported DBMS Systems

  • Oracle ® 8i - 21c
  • Microsoft ® SQL Server 6.5 - 2019
  • Microsoft ® Azure
  • IBM DB2 LUW ® 7.x - 11.x
  • IBM DB2 z/OS ® 7.x - 10.x
  • IBM DB2 iSeries ® 5.x - 7.x
  • Sybase ASE ® 10.x - 16.x
  • Sybase Anywhere ® 9.x - 12.x
  • Sybase IQ ® 12.5 - 16.x
  • MySQL ® 5.x - 8.x
  • PostgreSQL ® 8.2.x - 13.x
  • Informix ® 9.x - 11.x
  • Teradata ® 12.x - 14.x
  • Vertica ® 9.x
  • Kdb+ ®
  • Apache Hive
  • ODBC 3.0 compliant sources