What’s new in Database Workbench 5.7?

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.

SHARE THIS STORY

Share on facebook
Share on twitter
Share on linkedin
Share on email

RELATED POSTS

How to Invest in the Cannabis Industry

How to Invest in the Cannabis Industry

Despite cannabis (also known as weed or marijuana) being illegal in a large part of the world, the global cannabis market was worth US$28.26 billion in 2021 and is expected to grow to US$197.74 billion by 2028. Gone are the days when venture capital firms would dismiss cannabis companies as problematic investments.

Why Crypto Markets Crash and 5 Ways Investors Can Deal

Why Crypto Markets Crash and 5 Ways Investors Can Deal

With more and more people holding cryptocurrencies today, the crypto crash of May 2022 has had severe financial consequences. Reliable currencies, including Bitcoin and Ether, met a terrible fate, as did stablecoins, amounting to losses of over US$300 billion.

How Lemi Is Helping Small Businesses Reach Their Customers

How Lemi Is Helping Small Businesses Reach Their Customers

Starting a business isn’t easy. From finding raw materials and making your products to actually reaching the right customer base, everything takes a lot of time and energy. Even though this process is so hard, a lot of people venture out and start their own businesses, so much so that small business enterprises (SMEs) make up 90% of the world’s businesses.