ANN: Upscene releases Database Workbench 5.6.0

2019-02-26 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.6.0 " This new release brings you the Command Line Data Pump & Favorites feature (Pro Edition) and a few important bugfixes. Version 5.5 brought you

ANN: Database Workbench 5.5.0 released and free Lite Edition for MySQL

2019-01-15 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.5.0 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.5.0 " This new release brings you support for the latest versions of supported database systems, that

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

2018-10-30 Thread Martijn Tonies (Upscene Productions)
Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB

ANN: Upscene releases Database Workbench 5.4.6

2018-10-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.6 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.4.6 " This is a bugfix release, previous releases included support for MariaDB 10.1 and 10.2, MySQL 5.7 and

ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.4 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

ANN: Stored routine debugger Hopper, version 2.0.1 released

2018-06-27 Thread Martijn Tonies (Upscene Productions)
ts, binary data in variables and much more. For more information, see http://www.upscene.com/go/?go=news=20180627 With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Upscene releases Database Workbench 5.4.2

2018-03-06 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.4.2 Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.2 “ This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version

ANN: Upscene releases Database Workbench 5.4.0

2018-02-05 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.4.0 " This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure and the latest version of PostgreSQL. Previous releases included a

In MySQL 8.0, how does one recognize roles?

2018-01-09 Thread Martijn Tonies (Upscene Productions)
Hi, In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users But how does one distinguish between roles and users? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL

ANN: Upscene releases Database Workbench 5.3.4

2017-10-27 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3.4 " This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine

ANN: Stored routine debugger Hopper, version 2.0 released

2017-10-20 Thread Martijn Tonies (Upscene Productions)
Dear ladies and gentlemen, Upscene Productions is proud to announce version 2 of "Hopper", a stored routine debugger for InterBase, Firebird and MySQL. This version includes support for Firebird 3 packages and stored functions, MySQL diagnostic-statements, binary data in variables and much more.

Upscene releases Database Workbench 5.3.2

2017-06-30 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: “ Database Workbench 5.3.2 “ This release includes bugfixes on version 5.3 which included a custom report writer, increased support for PostgreSQL, a renewed stored routine

Upscene releases Database Workbench 5.3

2017-04-19 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.3 " This release includes a custom report writer, increased support for PostgreSQL, a renewed stored routine debugger with full support for Firebird 3

Starting MySQL takes a long long time

2016-10-10 Thread Martijn Tonies (Upscene Productions)
is causing the delay between starting InnoDB and finishing this startup? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.

ANN: Database Workbench 5.2 now includes PostgreSQL support

2016-09-08 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with different

ANN: Upscene releases Database Workbench 5.1.12

2016-03-23 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.12 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.12 “ This release adds a few small features and useful enhancements. The full version 5.1.x change log is available here:

Upscene releases Database Workbench 5.1.10

2015-12-16 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5.1.10 This release adds a few small features and includes Windows Terminal Server support. The full version 5.1.x change log is available here:

ANN: 20% discount on Database Workbench Basic or Pro!

2015-11-04 Thread Martijn Tonies (Upscene Productions)
here: http://www.upscene.com/database_workbench/ Thank you. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!

Upscene releases Database Workbench 5.1.6

2015-10-09 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.1.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.6 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The full version

Upscene releases Database Workbench 5.1.2

2015-07-15 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.2 This version is the next big release after version 5 and includes new features, enhancements and fixes. The change log is available here:

Upscene releases Database Workbench 5.1.0

2015-06-24 Thread Martijn Tonies (Upscene Productions)
For immediate release: http://www.upscene.com/news/item/20150624 Upscene releases Database Workbench 5.1.0 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1 This version is the next big release after version 5 and

Upscene releases Database Workbench 5.0.10

2015-02-20 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here: http://www.upscene.com/go/?go=trackerv=5.0.10id=12 Version 5 added

ANN: Upscene releases Database Workbench 5.0.8

2015-01-21 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.8 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 This release fixes several issues as reported by our customers. The change log is available here:

ANN: Advanced Data Generator 3.3.0 released

2014-12-17 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20141217 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Database Workbench 5.0.6 released

2014-12-15 Thread Martijn Tonies (Upscene Productions)
ANN: Upscene releases Database Workbench 5.0.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 Version 5.0.6 fixes an issue with the MySQL module and includes some changes for Firebird 3. The change log is available

Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)
Hi, This is an example: ALTER TABLE cart ADD CONSTRAINT fk_cart_customers FOREIGN KEY (custid) REFERENCES customers (custid) ON DELETE CASCADE ON UPDATE NO ACTION; (take from the GUI tool Database Workbench, avoids having to know the syntax ;) ) With regards, Martijn Tonies Upscene

Re: alter table for foreign key

2014-11-17 Thread Martijn Tonies (Upscene Productions)
a unique constraint (either a primary of a secondary unique constraint) to point to: when there's no uniqueness in the parent table, it cannot point to a record in that table. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL

ANN: Upscene releases Database Workbench 5.0.4

2014-10-16 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5.0.4 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5 Version 5.0.4 introduces some small new features and a list of fixes base on user feedback. The change log is available here:

ANN: Upscene releases Database Workbench 5.0.2

2014-09-18 Thread Martijn Tonies (Upscene Productions)
Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5 Version 5.0.2 fixed some issues that came to light after the initial major version 5 release. http://www.upscene.com/news/item/20140918 Version 5 added numerous

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
Hello Jan, list, From: Martijn Tonies (Upscene Productions) m.ton...@upscene.com Database Workbench now comes in multiple editions with different pricing models, there's always a version that suits you! Unless you don't do Winblows. Please put Windows dependency clearly in your

Re: database developer tool Database Workbench 5 now available

2014-09-05 Thread Martijn Tonies (Upscene Productions)
, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

ANN: database developer tool Database Workbench 5 now available

2014-09-04 Thread Martijn Tonies (Upscene Productions)
Upscene releases Database Workbench 5 Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool: Database Workbench 5 There have been numerous improvements to existing tools and the new, more consistent user interface is

Re: Stored procedure debuggers

2014-08-21 Thread Martijn Tonies (Upscene Productions)
called Hopper, I haven tried it under Wine yet, but there's a good chance it runs fine. Here's my latest (successful) attempt running Database Workbench under Wine, as a complete Linux novice. ;) http://www.upscene.com/support.php?page=dbw_ubuntu_wine With regards, Martijn Tonies Upscene

Re: Cannot Update, at least not how I'm telling it to!

2014-07-09 Thread Martijn Tonies (Upscene Productions)
The AND in your UPDATE clause makes this a logical operator instead of being a SQL keyword. Your syntax is wrong: UPDATE ... SET mycol = value, mycol2 = value [WHERE ... ] With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL

ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!

2014-06-17 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.7 Pro For more information, see

ANN: Hopper - Stored Routine debugger - v1.5.1 released

2014-06-16 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140616 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

Three days left on the 75% FIFA World Cup Discount!

2014-06-09 Thread Martijn Tonies (Upscene Productions)
Dear reader, There’s 3 days left on our FIFA World Cup special: 75% discount on all our database development products! http://www.upscene.com/ With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: 75% special FIFA World Cup 2014 discount on all our products

2014-05-26 Thread Martijn Tonies (Upscene Productions)
Hello everyone, We’re currently offering a 75% discount on all our (Windows based) products! This includes test data generator, development and debugging tools, feel free to take a look at http://www.upscene.com Thank you for your attention. With regards, Martijn Tonies Upscene

ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!

2014-04-29 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.6 Pro For more information, see

ANN: Hopper - Stored Routine debugger - v1.5.0 released

2014-04-01 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains new features and bugfixes, see http://www.upscene.com/go/?go=newsid=20140401 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Database Workbench 4.4.5, special MySQL discount!

2014-03-19 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.5, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.5 Pro March only: 25% discount on Database Workbench Pro for MySQL

ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!

2014-01-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.4 Pro For more information, see

ANN: Advanced Data Generator 3.2.0 released

2014-01-07 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20140107 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Advanced Data Generator 3.1.2 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
on www.upscene.com Pricing information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20131202 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.1 released

2013-12-02 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes, see http://www.upscene.com/go/?go=newsid=20131202b for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com

ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!

2013-11-27 Thread Martijn Tonies (Upscene Productions)
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.3 Pro This release fixes a blocking problem after a recent Windows

ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!

2013-10-24 Thread Martijn Tonies (Upscene Productions)
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.2 Pro There's a 15% autumn discount until the end of November! This release includes enhancements and fixes several bugs as

ANN: Advanced Data Generator 3.1.1 released

2013-10-14 Thread Martijn Tonies (Upscene Productions)
information available on: http://www.upscene.com/go/?go=purchase More information available here: http://www.upscene.com/go/?go=newsid=20131014 With regards, Martijn Tonies Upscene Productions - Database Tools for Developers http://www.upscene.com

ANN: Hopper - Stored Routine debugger - v1.4.0 released

2013-10-09 Thread Martijn Tonies (Upscene Productions)
information, see http://www.upscene.com/go/?go=hopper This release contains bugfixes and improvements, see http://www.upscene.com/go/?go=newsid=20131009 for more information. With regards, Martijn Tonies Upscene Productions http://www.upscene.com