DB Solo 4.0 Changes

New Features

Added Server Comparison Tool, which allows you to compare server-level objects (users, roles, databases, tablespaces, etc) between two database servers. This feature is currently supported for Oracle, MS SQL Server, Postgres and Sybase ASE.
Added a Server Scripting Tool
Added a procedure editor for Postgres
Added the ability to export and import Server Connections from one DB Solo installation to another
Added a folder compare tool that allows you to compare and sync files between two folders on your hard-drive
Added Support for Windows 7
Added Support for 64-bit Windows
Added Support for PostgreSQL 9

Query Editor

Added a column view panel, which allows one to view the selected row's values in a vertical table
You can right-click on the server connection drop-down and connect/disconnect the selected connection

Explain Plan

The plan graph can now be saved in various formats including SVG, VML, HTML, JPEG, etc.
Added a new Table-view that allows you to filter and sort the individual steps
Added 'Operator Cost' and 'Operartor Cost %' columns for SQL Server in the tree view
The Graph-view now shows 'Cost %' in each node
The node with the highest cost is colored red

Schema Browser

Added support for Server Groups. This allows you to organize your Server Connections in folders, e.g. 'PRODUCTION', 'QA', etc.
The table reference graph can now be saved in various formats including SVG, VML, HTML, JPEG, etc.
Added support for Oracle queues and queue tables
Added support for Oracle directories
Added support for Oracle database links and public database links
Added support for SQL Server linked servers
Added support for viewing and editing table & column comments for SQL Server
The Data-tab issues updates with the NOWAIT option for Oracle
Added support for SQL Server 2008 data type DATETIME2
Added support for MySQL table partitions
Added support for DB2 functions
Added support for advanced options in the Table Creator for DB2, Oracle, MS SQL Server, Postgres, Sybase SQL Anywhere and MySQL
Added support for SQL Server computed columns

Schema Compare

SQL Server table and column comments can now be compared
Sync script creator can now optionally include the schema names for DB2
Added support for Oracle queues and queue tables
Added support for Oracle database links
Added support for MySQL table partitions
Added a setting for ignoring whitespace when comparing check constraint definition
Added support for comparing DB2 tables' data/index tablespace
Added support for comparing DB2 functions
Differences in source code can now be viewed in a separate dialog
Source code difference panel now supports synchronous scrolling

Schema Scripting Tool

Data Compare Tool

The sync script can now be generated for either side
The tool can now create a separate sync script file for each table
Added the ability to treat empty strings as NULLs
Sync script can now optionally turn IDENTITY_INSERT ON for tables with identity columns [SQL Server]
Added Select/Deselect All buttons under Extra/Missing/Different tabs on the results page

User Management

Added 'Create Like' option to clone users for Oracle, DB2, Sybase ASE, MySQL, SQL Server and Postgres