What's new in DB Solo 4.3
Sep 10, 2014
New in DB Solo 4.2.9 (Feb 18, 2014)
New in DB Solo 4.2.8 (Jan 14, 2014)
New in DB Solo 4.2.7 (Oct 31, 2013)
- Added support for Vertica.
New in DB Solo 4.2.6 (Jul 3, 2013)
New in DB Solo 4.2.5 (Jun 4, 2013)
- Added support for SQL Server 2012.
New in DB Solo 4.2.4 (Feb 19, 2013)
- Result Set Comparisons can now be run from the command-line.
New in DB Solo 4.2.3 (Dec 19, 2012)
- Added support for MacOS 10.8
- Added support for MySQL Geometry data types
New in DB Solo 4.2.2 (May 29, 2012)
- Columns in the Data Compare Tool can be wrapped inside a SQL function.
- Added the ability in the Schema Compare Tool to only compare indexes with names that match a regular expression
- Added support for Oracle invisible indexes
New in DB Solo 4.2.1 (Nov 30, 2011)
New in DB Solo 4.2 (Oct 12, 2011)
- Added support for SQLite, including support in the Schema Comparison and Data Comparison Tools
- Added Explain Plan support for PostgreSQL
- Added support for DB2 Partitions
- CSV export now has the capability to escape quote characters
- Schema comparison tool can now compare Postgres sequence OWNED BY values
- Postgres 8.2 and later sequence OWNED BY is now scripted correctly
- Postgres foreign key DEFERRABILITY is now scripted correctly
- Added support for PostgreSQL arrays in the Data Compare Tool
- Table triggers are shown under a separate item under schema/database in the Schema Browser
New in DB Solo 4.1.2 (Mar 30, 2011)
- Schema Compare Tool has an option to ignore the case and quotes in the name of an Oracle function, procedure, package, collection type and object type
- Schema Compare Tool has an option to reduce memory consumption by discarding matching results for functions, procedures, packages, collection types and object types
- Schema Compare Tool results are now available also in XML and HTML formats
- Added support for selecting the file encoding for Data Compare Tool's sync script
- Added support for killing multiple sessions at the same time
New in DB Solo 4.1.1 (Feb 16, 2011)
New in DB Solo 4.1 (Feb 8, 2011)
- Added support for HSQLDB, including support in the Schema Comparison and Data Comparison Tools
- Schema Compare Tool's sync scripting now supports custom wrappers for identifiers
- Schema Compare Tool's sync scripting now supports the DELIMITER statement for MySQL
- Schema Scripting Tool now supports custom wrappers for identifiers
- MySQL signed vs. unsigned is now compared in the Schema Compare Tool
- Schema Compare Tool's text results now has an option to hide detailed source code differences
New in DB Solo 4.0.2 (Jan 24, 2011)
New in DB Solo 4.0.1 (Jan 20, 2011)
New in DB Solo 4.0 (Jan 18, 2011)
- Added Server Comparison Tool, which allows you to compare server-level objects (users, roles, databases, tablespaces, etc) between two database servers.
- Added Server Scripting Tool
- Added PostgreSQL Function Editor
- 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 PostgreSQL 9
New in DB Solo 4.0.1 Beta 1 (Oct 13, 2010)
- 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
- 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 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 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:
- SQL Server table and column comments are now scripted
- The script can now optionally include the schema names for DB2
- Added support for SQL Server 2008 data type DATETIME2
- Added support for MySQL table partitions
- Added support for Oracle queues and queue tables
- Added support for DB2 functions
- Added support for SQL Server computed columns
- 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
New in DB Solo 3.8.2 (Jun 8, 2010)
New in DB Solo 3.8.1 (Mar 31, 2010)
- Data Compare tool can now select unique constraint columns automatically when no PK is present.
- Added 'OS User' column to the Oracle sessions view.
- Bug fixes
New in DB Solo 3.7.5 (Sep 1, 2009)
- Support for displaying the Sybase ASE execution plan was added.
- The schema compare tool was enhanced to optionally compare privileges granted to objects.
- Support for SQL*Loader scripts was added in the data compare tool.
New in DB Solo 3.7.3 (Apr 28, 2009)
- Support for custom key bindings was added
- Query Editor now supports result set comparisons. Compare two result sets and quickly identify differences between them. You can also save result sets for later comparisons.
- Query Editor and Export Tool now support XML and Excel output formats
- Query Editor supports substitution variables, allowing one to write parametrized queries
- Added support for SQL Server Agent, including configuration for Jobs, Alerts and Operators
- MySQL JDBC driver is now bundled with DB Solo
New in DB Solo 3.7.2 (Mar 17, 2009)
- Support for PostgreSQL user management was added.
New in DB Solo 3.7 (Feb 10, 2009)
- A result set comparison feature was added that allows one to compare two result sets and quickly identify differences between them.
- The Query Editor and Export Tool now supports XML and Excel output formats.
- Support for custom key bindings was added. Support for SQL Server Agent was added, including configuration for Jobs, Alerts, and Operators.
New in DB Solo 3.7 Beta (Jan 6, 2009)
- A result set comparison feature was added that allows one to compare two result sets and quickly identify differences between them.
- The Query Editor and Export Tool now supports XML and Excel output formats.
- Support for custom key bindings was added.
- Support for SQL Server Agent was added, including configuration for Jobs, Alerts, and Operators.
New in DB Solo 3.5 (Sep 9, 2008)
- Stored procedure editors for MS SQL Server and Sybase were added as well as a stored procedure editor and debugger for Oracle.
- Numerous enhancements to the schema and data compare tools were also added.