What's new in DB Solo 5.3.5
Sep 25, 2023
- Added support for Oracle hints in Data Compare Tool
- Primary key columns are indicated in the HTML report in Data Compare Tool
New in DB Solo 5.3.2 (Jan 29, 2023)
- Added support for Postgres 15
- Fixed CREATE INDEX scripting for MySQL text and blob columns
New in DB Solo 5.3.1 (Oct 31, 2021)
- Added support for Azure SQL Database
New in DB Solo 5.3.0 (Oct 31, 2021)
- Added support for MySQL 8
New in DB Solo 5.2.5 (Jan 3, 2020)
- Added a new Data Search Tool
- DB2 BLOB/CLOB columns are scripted correctly
- Schema Compare Tool: Trigger enabled/disabled flag can be compared
- Data Comparison start/end time shown in the HTML report and sync script
- Data Comparison summary shown on the results page
- Data Compare Tool: Postgres json columns handled correctly
New in DB Solo 5.2.4 (May 7, 2019)
- Data Compare Tool: Added support for Postgres geometry type
- Data Compare Tool: Allow primary key columns in different order between source and destination
- Data Compare Tool: Easier to include a subset of all tables/views
- MySQL: FULLTEXT indexes correctly scripted
- Import Tool: Postgres enum types imported correctly
- Added Support for Postgres 11
- Table reference graph now shows ON DELETE/UPDATE rules for Postgres
- Schema Compare Tool can now compare WITH/WITHOUT OIDS for Postgres
- Add Trigger functionality supported for Postgres
New in DB Solo 5.2.3 (Jan 11, 2018)
New in DB Solo 5.2.2 (Jan 8, 2018)
- Added support for Postgres 10
- Added support for Postgres enums
- Server group information is now included when importing/exporting connections
- Added support for SQL*Plus spool command
New in DB Solo 5.2.1 (Jan 3, 2017)
- Added support for Postgres 9.6
- Oracle RAW data type length is checked in the Schema Comparison Tool
- Fixed an issue in the Data Compare Tool with SQL Server datetime2 column data type
- SQL export of Vertica timestamps now works correctly
- Fixed issues with scripting DB2 object permissions
New in DB Solo 5.2 (Oct 10, 2016)
- Added a data extraction tool that can extract all related rows in parent/child tables
- Schema Comparison Tool can now compare DB2 index clustering
- Data Compare Tool SQL script creator can insert a commit after every N statements
- Added support for SQL Server extended properties
- Bug fixes
New in DB Solo 5.1 (Oct 11, 2015)
- Added support for Cassandra
- Bug fixes
New in DB Solo 5.0.3 (Jun 22, 2015)
- Added support for SQL Server nokey index columns.
New in DB Solo 5.0.2 (Apr 27, 2015)
New in DB Solo 5.0.1 (Apr 10, 2015)
- Several Vertica-related bugs were fixed
New in DB Solo 5.0 (Mar 31, 2015)
- Added support for Java 1.8 on Linux
New in DB Solo 5.0 Beta 4 (Mar 9, 2015)
- Individual records can be selected for sync script for file-based comparison in the Data Compare Tool
- The schema scripting tools allows one to select objects for based on the name of their schema using regular expressions (SQL Server).
- SQL Server nonkey index columns are scripted correctly in the Schema Compare Tool as well as the Schema Scripting Tool.
New in DB Solo 5.0 Beta 3 (Feb 23, 2015)
- Added support for Mac OS X Yosemite
New in DB Solo 5.0 Beta 2 (Feb 23, 2015)
- DB2 index schema can now be compared in the Schema Compare Tool
- Added an option for server connections to persist the default schema/database to be shown in Query Editor
- Support for SQL Server 2014 was added
- Support for Postgres 9.4 was added
- Data type change from Oracle VARCHAR2 to CLOB is now scripted correctly in the Schema Compare Tool
- Nanoseconds can now be optionally shown when timestamp-datatype is displayed
New in DB Solo 5.0 Beta 1 (Dec 8, 2014)
- New Features:
- Support for Oracle 12c was added
- Support for DB2 nicknames was added
- SQL Server 2012 sequences was added
- Support for DB2 roles was added
- Support for PostgreSQL view triggers (instead-of-triggers) was added
- Oracle connections can be created using TNSNAMES descriptors
- Support for DB2 LUW 10.x was added
- Support for solidDB 7.x was added
- Support for Postgres 9.3 was added
- Oracle NLS parameters can be specified in settings
- Schema Compare Tool:
- Tool now supports comparing against saved snapshots of databases/schemas (offline schema comparison)
- Newline (Win/Unix) option for SQL sync script was added
- Postgres partial index constraint is now compared
- Postgres exclusion constraints are now compared
- Postgres timestamp precision is now compared
- Precision is now compared for MySQL temporal data types (TIME, DATETIME, TIMESTAMP)
- Data Compare Tool:
- Multiple records can be selected in the results table
- Option not to include matching tables on the main page of HTML reports was added
- Schema Scripting Tool:
- Postgres partial index constraint is now scripted
- Postgres exclusion constraints are now scripted correctly
- Precision is now scripted for MySQL temporal data types (TIME, DATETIME, TIMESTAMP)
- Schema Browser:
- Self-references (foreign key to the same table) are now shown in the table references tab
- Database can be added as a favorite object
- Postgres partial index constraint is now shown in index panel
- Other:
- Dozens of bugs were fixed
New in DB Solo 4.3 (Apr 8, 2014)
- SQLite-related bug fixes.
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 29, 2013)
- Added support for Vertica
New in DB Solo 4.2.6 (Jul 2, 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 18, 2012)
- Added support for MacOS 10.8
- Added support for MySQL Geometry data types
New in DB Solo 4.2.2 (Jun 19, 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 (Nov 30, 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 29, 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 11, 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.1 (Jan 20, 2011)
New in DB Solo 4.0 (Jan 18, 2011)
- Added support for Oracle database links in the Schema Browser as well as Schema Comparison and Schema Scripting Tools
- Added support for Oracle public database links in the Schema Browser as well as Server Comparison and Server Scripting Tools
- Support for PostgreSQL 9 was added
New in DB Solo 4.0 Beta 1 (Oct 12, 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.7.2 (Mar 17, 2009)
- Support for PostgreSQL user management was added in this release.
New in DB Solo 3.7 (Feb 10, 2009)
- Support for custom key bindings
- Query Editor and Export Tool now support XML and Excel output formats
- Added support for SQL Server Agent, including configuration for Jobs, Alerts and Operators
- Query Editor now supports result set comparisons
- MySQL JDBC driver is now bundled with DB Solo
New in DB Solo 3.5 Beta 1 (Jun 24, 2008)
- Oracle Stored Procedure Editor & Debugger was added
- Stored Procedure Editor was added for SQL Server
- Stored Procedure Editor was added for Sybase ASE
- Export tool was added which allows you to export unlimited number of rows to a CSV, HTML or SQL file
- Added support for Oracle 11g
- Added support for SQL Server 2008
- Data Import Tool: Import settings can now be saved to a project file
- Schema Browser: Added support for Oracle table partitions
- Schema Browser: Added support for Oracle global temporary tables
- Schema Browser: Added support for Postgres table rules
- Schema Browser: Data tab can automatically retrieve table/view data when the tab is selected
- Schema Scripting Tool: Added support for Oracle table partitions
- Schema Scripting Tool: Added support for Oracle global temporary tables
- Schema Scripting Tool: Added support for Postgres table rules
- Query Editor: Result sets can now be exported as SQL INSERT statements
- Schema Compare Tool: Added support for Oracle table partitions
- Schema Compare Tool: Added support for Oracle global temporary tables
- Schema Compare Tool: Added support for Postgres table rules
New in DB Solo 3.0 (Feb 26, 2008)
- Schema Scripting Tool allows you to create a DDL script for your entire schema
- Import Tool lets you import data from CSV or fixed-length files into a table
- Support for Sybase SQL Anywhere (ASA) was added
- Added support for SQL Server 2000 & 2005 user management, including the ability to add/modify/drop database users, database roles and server logins
- Added support for Sybase ASE user management, including the ability to add/modify/drop database users, database roles and server logins
New in DB Solo 2.2.6 (Oct 1, 2007)
- Table Data Comparison Tool lets you compare table data between different databases and produce a synchronization script to reconcile the differences.
- Schema Comparison Tool now supports Sequences and Oracle Packages.
- J2EE Code Generator. Many-to-many relationships as well as Oracle XMLType are now supported.