Chat now with support
Chat with Support

Toad Edge 1.1 - Release Notes

Release Notes

Toad Edge™ 1.1.0

Toad Edge™ 1.1.0

Release Notes

August 2017

These release notes provide information about the Toad Edge release.

About Toad Edge™ 1.1.0

Toad Edge™ is a database management application that allows you to perform database administration tasks with ease.

Toad Edge™ allows you to:

  • Connect to your MySQL database, view, explore and edit database structure, database objects and properties
  • Manage database objects, easily add, edit or drop objects in Object Explorer
  • Manage data stored in your database, add, edit or remove records
  • Write complex SQL code comfortably in Worksheet
  • Compare and synchronize databases using powerful Schema Compare
  • Obtain detailed information about your databases

Toad Edge 1.1.0 is a new release. See Features for more information.

 

Features

Release Notes > Features

Features of Toad Edge

In Toad Edge™ 1.1.0 the following new features were implemented:

General features

Support for Windows and macOS

  • Toad Edge runs on both Windows and macOS operating systems
  • See System Requirements for more information on supported operating systems

Enterprise Technical Support

  • Commercial editions of Toad Edge come with Quest enterprise technical support
  • Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com
  • The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:
    • Submit and manage a Service Request
    • Download software and technical documentation
    • Chat with support engineers online
    • And more...

Object Explorer

  • Manage database objects, easily add, edit or drop objects in Object Explorer
  • Right-click a database object to perform actions like Export Data

Object Detail Editors

  • Edit database objects with ease
  • Manage data stored in your database, add, edit or remove records
  • Obtain detailed information about your databases
  • Display object scripts and export them to Worksheet

SQL Worksheet

  • Write complex SQL code comfortably in Worksheet with Content Assist
  • Content Assist helps you write your code more quickly
  • Press CTRL (⌘) + SPACEto invoke Content Assist at any time
  • Results of SELECT statements are displayed in the Result Set
  • Where applicable, the results can be edited in-place and the changes can be immediately saved

SQL Query Monitor

  • View the history of both internal and user executed queries
  • You can copy the log or export the executed SQL script to a file

Export Data

  • Use Export Data Wizard to easily export data from tables
  • Right-click a table in Object Explorer and select Export Data
  • You can also export table/view records and query results
  • Configure export options such as destination, format, range of exported data and others in wizard

Import Data

  • Use Import Data Wizard to quickly import data to tables
  • Right-click a table in Object Explorer and select Import Data
  • You can import data from SQL or CSV files or ZIP archives with SQL/CSV content

Schema Compare and Synchronize

  • Compare and synchronize databases using powerful Schema Compare
  • Click Compare button to launch Schema Compare Wizard
  • Select source and target databases and schema comparison settings
  • Generate and export change scripts for target and source databases, save results and much more

Repository

  • Map your databases to a file system as a repository
  • The database metadata is represented as a structure of folders and JSON files representing objects
  • Track the repository in your favorite version control system

Continuous Integration and Delivery

  • Generate files and scripts to perform certain tasks (such as comparing databases, generating change scripts or reports...)
  • Use the files and scripts in continuous integration system of your choice (Jenkins, TeamCity, etc.) to perform these tasks automatically
  • If you use Jenkins, you can install a plugin that allows you to easily set up automated tasks

Advanced user privilege management

  • Grant and revoke user privileges for any object on several levels using a convenient interface
  • Privileges can be viewed both from user and object point of view
  • Also supported are wildcard pattern privileges and proxy privileges

Database Snapshot

  • Snapshots represent your database structure at specific time as a JSON file
  • Right-click your database and select Take Snapshot
  • Stored Snapshots are displayed in Snapshots View
  • Compare and synchronize snapshots with the current state of your active database using Schema Compare
  • Export the snapshot SQL script to a file, clipboard or Worksheet

Code snippets and templates

  • Create, modify and reuse code templates in either SQL or JSON context
  • The created templates can be applied at any time using Content Assist

Session Browser

  • View, inspect and terminate any sessions of any database you are connected to

MySQL JSON support and Editor

  • MySQL 5.7 offers support for native JSON (JavaScript Object Notation) datatype
  • See the structure of JSON columns in both Object Explorer and Outline View
  • Go to Data tab in Object Detail of a table that contains a JSON datatype column
  • Edit any JSON value easily in an advanced editor by clicking the Define in Editor button
  • Utilize Content Assist while working with your JSON scripts
  • Turn on Brackets highlighting or Brackets content highlighting to visualize script segments
  • Use Outline View to see the structure and navigate JSON scripts

  • Use Quick Fix to resolve simple syntax errors in your JSON code

MySQL events support

  • Create new events using an intuitive wizard
  • Configure the start, end and other time settings of events

Database features

Support for MySQL 5.5, 5.6 and 5.7

  • Toad Edge™ supports the three latest MySQL versions

Support for on premise and Amazon RDS MySQL

  • Use full Toad Edge functionality with your on-site or cloud databases

Known Issues

Release Notes > Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.

General known issues

Known Issue Issue ID

Mouse cursor may become invisible in specific circumstances related to errors in Worksheet.

Workaround: Switch into a different Toad Edge View and back.

5942
After upgrading from Toad Edge 1.0 , databases that were mapped (as part of Repository) will lose their mapping. 8223

When a database is synchronized with Repository, changes made to tables in the database that have been created using BLACKHOLE, CSV or FEDERATED engine are not detected in Object Explorer.

Workaround: Display the comparison window (right-click the database | Repository | Synchronize). The changes will be detected and subsequently displayed in Object Explorer.

8332

After upgrading from Toad Edge 1.0, the latest MySQL JDBC driver is not automatically mapped.

Workaround: Map the latest driver manually in Preferences | Database. The driver can be found in C:\Program Files\Quest Software\Toad Edge\lib\drivers.

8536
Toad Edge changes double quotes to single quotes in synchronization script generated for stored procedures, events and triggers which using dynamic SQL. 8750

Third-party known issues

Known Issue Issue ID

Setting up increased DPI (125%) causes some Toad Edge Tab labels to display incorrectly.

Workaround: Set DPI to 100%.

6515

Loading identical Table Details on two connections may cause the dialogs that modify these tables to freeze.

Workaround: End Toad Edge using Task Manager.

7517
After removing the Primary Key and making the column unique, MySQL still keeps PRI as the column key in columns table. 7249
MacOS connections to Amazon RDS databases may automatically expire and be dropped. 7621
Year 2000 in Year(2) data type (00) is not correctly represented in Object Detail or Result Set as JDBC driver raises an exception if the value of the year is 0. Such values are represented in grids as unknown. 8264

Names of functions with special characters are not stored properly in a database even when UTF-8 encoding is used. This can cause side effects such as not being able to grant a privilege to a function as its name in query is different from the actual stored name.

Workaround: Replace special characters by basic (ASCII).

7287
MySQL time values are displayed as (invalid value) in Object Detail and Result Set if they are outside the range 00:00:00-24:00:00. This is a limitation of JDBC driver. 8236

On Windows 10 closing a tab in Toad Edge using a drop-down menu may close other tabs than intended.

8478

Batch files that use UTF-8 BOM encoding cannot be executed by the Toad Edge command line interface.

Workaround: The CI/CD Wizard in Toad Edge generates files using pure UTF-8 encoding. Do not change the encoding once the files are generated.

8486

Updating system Java may delete certain Toad Edge libraries. This results in the application being unable to connect to databases or obtain licenses.

Workaround: The only way to restore the deleted files is to reinstall Toad Edge

8603

System Requirements

Release Notes > System Requirements

Before installing Toad Edge 1.1.0, ensure that your system meets the following minimum hardware and software requirements.

NOTE: Toad Edge™ is distributed with the latest MySQL Connector/J 5.1.42 and with Java Runtime Environment 1.8.0_121.

Hardware requirements

Requirement Details
Processor Minimum dual core 64-bit processor
Memory Minimum 4 GB RAM
Hard disk space Minimum 500 MB + additional disk space for user data

Software requirements

Requirement Details
Operating System

Windows 10 (64-bit)

Windows 8.1 (64-bit)

Windows 7 (64-bit)

Windows Server 2012 R2 (64-bit)

macOS 10.12 Sierra (64-bit)

OS X 10.11 El Capitan (64-bit)

Other requirements .NET 4.0 is required to install the application on Windows 7

NOTE: Toad Edge may also run on virtual versions of the mentioned operating systems. Please note, however, that these configurations were not tested.

Database requirements

Supported database Version MySQL Engines
MySQL

5.5, 5.6, 5.7

InnoDB, MyISAM

Other Requirements

Internet connection In order to sign-in and validate your license internet connection is required to connect with our licensing servers.
Internet browser

In order to view documentation an internet browser is required.

Internet Explorer 10 or later is recommended.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents