Home > Computing > What's new in Database Workbench 5.7?

What's new in Database Workbench 5.7?

Added: (Wed Apr 08 2020)

Pressbox (Press Release) -

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.

Submitted by:Martijn Tonies
Disclaimer: Pressbox disclaims any inaccuracies in the content contained in these releases. If you would like a release removed please send an email to remove@pressbox.com together with the url of the release.