SqlDbx is a fast and easy to use database SQL development IDE for database administrators, application and database developers who work 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 straight-forward interface allows developers to improve their productivity by having easy access to commonly used features. Run queries, execute scripts, and browse database objects without leaving the editor window. SqlDbx is a standalone executable file, so no installation is necessary. Furthermore, SqlDbx does not install or modify anything on the user's computer.

Features:

  • High performance native support for major Database Servers including Microsoft, Sybase ASE, Oracle and IBM DB2/UDB
  • Browse / 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 / 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
  • Sort, filter, format, retrieve parent / child data rows, export and transpose data in Result Grid
  • Execute procedures and functions with automatic argument specification
  • Display query plan and query statistics
  • Administrative Views
  • Portable mode
  • Simple deployment and removal. No dll's or other dependencies. Just one executable (1.9 meg.)

Supported DBMS Systems

  • Oracle ® 8i - 11g R2
  • Microsoft ® SQL Server 6.5 - 2012
  • Microsoft ® Azure
  • IBM DB2 LUW ® 7.x - 10.x
  • IBM DB2 z/OS ® 7.x - 10.x
  • IBM DB2 iSeries ® 5.x - 7.x
  • Sybase ASE ® 10.x - 15.x
  • Sybase Anywhere ® 9.x - 12.x
  • Sybase IQ ® 12.5 - 16.x
  • MySQL ® 5.x
  • PostgreSQL ® 8.2.x - 9.x.x
  • Informix ® 9.x - 11.x
  • Kdb+ ®
  • ODBC 3.0 compliant sources