Chat now with support
Chat with Support

Toad Edge 1.1 - User Guide

Introduction

About Us

Introduction > About Us

About Quest

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.

For sales or other inquiries, visit www.quest.com/contact.

About Toad Edge™

Introduction > About Toad Edge

About Toad Edge™

Toad Edge™ is a next-generation tool for today’s complex database environments

Toad Edge™is a flexible Java based toolset for the development and management of open source relational databases. It is built to reduce the learning curve for developers and DBAs working in next-generation database environments. The initial release of Toad Edge™ supports MySQL.

Features

Toad Edge™ allows you to:

  • Connect to your MySQL database on premise or in cloud
  • 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
  • Monitor running SQL queries in progress
  • Compare and synchronize databases using powerful Schema Compare
  • Obtain detailed information about your databases
  • Edit JSON script in an advanced Editor
  • Take database Snapshots and much more

Features of Toad Edge™

Introduction > Features of Toad Edge

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
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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating