Release Notes

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

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

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

Third-party known issues

System Requirements

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

Hardware requirements

Software requirements

Database requirements

Other Requirements