SqlDbx 3.32

SqlDbx 3.32 is an effective and user-friendly Database IDE / SQL editor / SQL query tool for database and application developers. 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.

Major Features:

1. High performance native support for major Database Servers including Microsoft, Sybase ASE, Oracle and IBM DB2/UDB
2. Browse / Explore Servers
3. Fast, intelligent, extensive and highly customizable Intellisense
4. Advanced Script Editor with Syntax highlighting, Auto Complete, Speed Typing, Script Variables, Drag/Drop, Column (Block) Mode
5. Automatically highlight matching parenthesis and BEGIN/END, IF/END IF, CASE/END, ... SQL blocks
6. Full Unicode support in Script Editor and Result Grid
7. Visual Data Diff, File Diff, Quick Diff
8. SQL Object Scripting
9. SQL Formatter / Beautifier
10. Generate SELECT, INSERT, UPDATE, DELETE, CREATE, WHERE IN data modification statements directly from Result Grid
11. SQL Templates with support for formal parameters
12. Parameterized Queries and substitution variables
13. Import / Export to CSV, XML, Excel
14. Schema Object browser
15. SQL statement execution history
16. Favorite objects. Find object
17. Search in Database and in Result Grid
18. Directly edit table data in Result Grid
19. Sort, filter, format, retrieve parent / child data rows, export and transpose data in Result Grid
20. Execute procedures and functions with automatic argument specification
21. Display query plan and query statistics
22. Administrative Views
23. Simple deployment and removal. No dll's or other dependencies. Just one executable (1.5 meg.)

Enhancements:

• Added ability to select multiple objects in Object pane using SHIFT key.
• Added ability to select multiple items in Intellisense popup window.
• Added option to specify order of table columns in Intellisense popup window
• Added option to enable number of returned rows by default
• Added option to modify query results directly in Result Grid
• Added ability to modify table data for tables with no unique constraints
• Added new option to float and dock Object View, Edit and Result tabs
• New Editor feature. Go to Line (Ctrl+G) and Mark all occurrences of a word (Ctrl+M)
• New Editor feature. Automatically highlight matching parenthesis
• New Editor feature. Automatically highlight matching BEGIN/END IF/END IF, CASE/END, ... SQL blocks
• Improved generate SELECT/INSERT/UPDATE statement
• Added new option to generate SQL Plus compatible scripts for Oracle
• Changed XML export format. Corrected date format
• Fixed out of memory error when exporting table data to file
• Fixed generation of execute script for Oracle package procedures
• Fixed custom object filter not working
• Fixed Shift key operation in Result Grid
• Fixed exception when copying from Result Grid
• Fixed exception when canceling Oracle queries
• Fixed error when executing Oracle stored procedures with multiple output cursors
• Fixed slow Intelliesense for Oracle and DB2
• Fixed couple system catalog queries for DB2 z/OS