Overview of SqlDbx

hjw100

SqlDbx 是简单易用的数据库设备，SQL编辑，SQL查询工具。语句规则突出，智能化，自动完成，等等特色功能多多。支持Oracle,Sybase ASE, IBM,DB2/UDB, MicrosoftSQL Server 和ODBC数据源.

SqlDbx is a fast and easy to use database SQL development IDE for database administrators and application or database developers who work in heterogeneous Database Server environments. SqlDbx 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 the most commonly used features. Run queries, execute scripts and browse database objects without leaving 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 at a glance:

• 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 and BEGIN/END, IF/END IF, CASE/END, ... SQL blocks
• Full Unicode support in Script Editor and Result Grid
• x64 Version
• Visual 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
• Simple deployment and removal. No dll's or other dependencies. Just one executable (1.5 meg.)

Supported DBMS Systems

• Oracle® 8i - 11g
• Microsoft® SQL Server 6.5 - 2008
• IBM DB2 LUW ® 7.x - 9.x
• IBM DB2® z/OS 7.x - 9.x
• IBM DB2® iSeries 5.x - 6x
• Sybase ASE® 10.x - 15.x
• Sybase Anywhere® 9.x - 11.x
• Sybase IQ® 12.5 - 15.x
• ODBC 3.0 compliant sources