Toad Edge 2.0.8 - Installation Guide

Introduction

Introduction

Toad Edge® can be installed from packages available on Toad World

  • Windows Installer Package (MSI)
  • macOS Installer Package (PKG)

Online authentication

A Quest Software account is required in order to use Toad Edge. If you do not have a Quest account yet, you can create one after launching the application.

Toad Edge requires you to perform online authentication by signing in to your Quest account at least once per every 30 days. If you are signed in to your account and Toad Edge is able to reach the authentication servers, the process is done automatically on each application launch.

At times, the authentication may not be performed for various reasons, e.g. firewall settings, lack of internet connection. In such cases, the following situations may occur:

Toad Edge has been installed, but has not been authenticated yet

  • You are asked to sign in to your Quest account in order to authenticate the application for the first time and use it

Toad Edge cannot reach authentication servers. It has been less than 30 days since the last authentication

  • A warning dialog is displayed. You still can access the application up until the 30 day mark

Toad Edge cannot reach authentication servers. It has been at least 30 days since the last authentication

  • A warning dialog is displayed. You cannot access the application until you sign in to your Quest account

NOTE: Offline method of licensing is available for users, whose connection to the internet is restricted. See Offline licensing for more information.

Product Licensing

Product licensing

Three types of licenses are available for Toad Edge:

  • Freeware - basic mode which is active when no other license is supplied
  • Trial - unlimited mode which lasts for a set period (for example, the initial 30-day Trial)
  • Commercial - unlimited mode gained by purchasing and using a Commercial license in the application

As mentioned in Introduction, you need to create and sign in to your Quest Software account in order to start using Toad Edge. After you create your account, you are provided an initial 30-day Trial license. This allows you to try out the application and all of its features.

Once the Trial period elapses, you can purchase and supply a Commercial license to continue using Toad Edge without limitations. Otherwise, the application will revert to the Freeware mode. You will be still able to use all Freeware features, but you will not be able to access Commercial features.

The following matrix lists all features that can be used in Freeware and Trial/Commercial versions of Toad Edge.

Feature Commercial Freeware

SQL Worksheet/Editor

Advanced Content Assist
Syntax check
Code formatting
Multiple statement execution
Execution from/to position

Data editor

Table lookup via foreign keys
Basic data filters
Data type specific data editors
Editable result grid

Export and import

Export to CSV
Export to SQL
Export to HTML
Export to XML
Import from SQL
Import from CSV

Schema Compare

Schema/Database comparison
Advanced SQL difference recognition
Detailed SQL comparison settings
Timestamp comparison
Detailed Schema Compare reports
Generation of change scripts

Snapshots

Snapshot creation
Snapshot comparison

Versioning/Collaboration

Repository (MySQL only)
Continuous Integration/Continuous Delivery support
Native plugin solution for Jenkins

Other application features

Object search
Code snippets/templates
Session browser
Support for JSON data types
JSON structure visualization
JSON in-place data editor
MySQL Events editor
Advanced user privilege management

Offline Licensing

For users with restricted or no access to the internet Quest offers an alternative pathway of offline licensing. After having purchased an offline license of Toad Edge you will obtain a license file, e.g. license.dlv and you will not be required to sign-in to your Quest account. See Product licensing for more information.

To activate offline license on Windows

  1. Create a file called license.cfg and place it in “configuration” folder in Toad Edge installation folder, e.g. “C:\ProgramData\Quest Software\Toad Edge
  2. Open license.cfg and enter a path to each license file on a new line, e.g. “C:\Users\johndoe\Documents\Licences\license.dlv”
  3. Launch Toad Edge and it will automatically find the license and validate it offline

To activate offline license on macOS

  1. Create or locate a file called license.cfg and place it in Applications/Toad Edge/Contents/eclipse/configuration
  2. Open license.cfg and enter a path to each license file on a new line, e.g. “Users/johndoe/Documents/Licences/license.dlv”
  3. Launch Toad Edge and it will automatically find the license and validate it offline

NOTE: When using a terminal on macOS, please, keep in mind that different symbols might be inserted in place of spaces. However, these symbols must not be in the configuration file.

System Requirements

System requirements

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

Hardware requirements

Table 1: 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

Table 2: 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.14 Mojave (64-bit)

macOS 10.13 High Sierra (64-bit)

macOS 10.12 Sierra (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 are not tested.

Database requirements

Supported database Version Additional details
PostgreSQL

9.5, 9.6, 10, 11

Toad Edge tested with Amazon Aurora PostgreSQL 9.5 and Microsoft Azure PostgreSQL 10.1

EnterpriseDB 9.6, 10  
Amazon Redshift 1.0

Currently in beta

You need to use RedshiftJDBC42-1.2.12.1017 or newer driver in order to use Redshift features.

MariaDB 10.1, 10.2 MariaDB 10.1 tested for common functionality with MySQL 5.6
MySQL 5.5, 5.6, 5.7, 8.0*

MySQL 5.6 tested to run in Microsoft Azure. MySQL 5.7 tested to run in Amazon Relational Database Service (RDS) environment

MySQL engines: InnoDB, MyISAM

Tested MySQL editions: Community, Standard, Enterprise

*Role Management and Tablespaces are currently not supported for MySQL 8.0. Please use the latest driver with MySQL 8.0 support.

How to install JDBC drivers

The following JDBC drivers are supplied with the installation of Toad Edge. The current drivers bundled with the Toad Edge are Advanced Server JDBC Connector 4.2, MySQL Connector/J 5.1.46, and PostgreSQL JDBC 42.2.2.

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