Select Page

March 17, 2020 — Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: Database Workbench 5.7.0. Here’s the full list of changes:

New Features
MySQL Module: Support CHECK constraints for MariaDB 10.2.1 and MySQL 8.0.16 onwards
MySQL Module: Support MySQL ‘prepared statements’ in syntax check & debugger
MySQL Module: Support for user session variables (@myvar) in debugger and syntax check
PostgreSQL Module: Support for PostgreSQL 12

Enhancements
ADO/ODBC Explorer: Distinguish between (N)CHAR and (N)VARCHAR on ADO connections when possible
Firebird Module: Ability to include ‘deterministic’ flag for Stored Functions
General: Open Package Editor when double clicking package entry in dependencies
Meta Data Compare & Migration: Migrating NexusDB ‘autoinc’ to PostgreSQL fails with ‘datatype not supported’ message, map to BigSerial

Bug fixes
Firebird Module: Page buffer edit on Database Property dialog has invalid ‘max value’ restriction for Firebird 3 and up
Firebird Module: Extracting packages can cause problems when running script
Firebird Module: Package dependencies not displayed correctly
General: Checkboxes in SQL/Script Editor are double-scaled
‘current date/time’ default not properly migrated from PostgreSQL to others
Meta Data Compare & Migration: Stored Function parameters not modified in some modules
MySQL Module: Using SSL with password protected key files raises missing password error
MySQL Module: ‘trace into’ disabled when calling stored procedures, enabled for stored functions

About Database Workbench
Database Workbench is a database developer tool, over 18 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. For more information, please visit https://www.upscene.com/database_workbench/

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 18 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.