Chat now with support
Chat with Support

We are currently conducting maintenance on our telephony system. If you are experiencing an issue calling Support and you have a product issue requiring technical assistance, please login to submit or update your Service Request. If additional assistance is needed, please leave a voicemail for a response from Customer Service.

Toad Edge 2.0.7 - User Guide

Introduction

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.

Features

Toad Edge® allows you to:

  • Connect to your databases 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

About Us

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.

Getting Started with Toad Edge

Getting started with Toad Edge 2.0.7

Contents of installation package

The Toad Edge release package contains the following:

  • Installation file of Toad Edge 2.0.7 (MSI or PKG)
  • Product Documentation, including:
    • Release Notes
    • Installation Guide
    • User Guide

NOTE: Toad Edge® is distributed with the latest Advanced Server JDBC Connector 4.2, MySQL Connector/J 5.1.46, and PostgreSQL JDBC 42.2.2 .

Installation Instructions

  • See System requirements before installation to avoid any possible issues during installation or later when using Toad Edge
  • Launch Toad Edge installation file and follow the instructions in the installation wizard

How to Install Java Cryptography Extension

  • Download the latest JCE files:
    • local_policy.jar
    • US_export_policy.jar
  • and use them to replace the files in Toad Edge security folder
    • (...)\Quest Software\Toad Edge\bin\jre\lib\security\

Additional resources

Additional information is available from the following:

Toad World Community Site Toad Edge Toad World Community.

Commercial Features

While Toad Edge® is free to use for everyone in its basic Freeware version, the most advanced features are available to users with Trial or Commercial licenses. This topic aims to guide you through all of the extra functionality that could be useful in your production.

NOTE: A comprehensive comparison matrix of Freeware and Commercial versions can be found here.

JSON structure visualization
  • JSON columns, usable in MySQL 5.7 and newer, can be easily viewed in Object Explorer even when they are nested
JSON data editor
  • Instead of struggling to change a particular value in complex JSON data, you will be able to use an in-built editor with advanced bracket highlighting options
MySQL event editor
  • While you can see Events in Freeware version of Toad Edge, you will be also able to edit these objects directly in Object Detail
  • New Object Wizard will also help you to create new Events with ease
Advanced user privilege management
  • One of the most valuable features for database administrators is the ability to grant and revoke various user privileges at server, user or even object level
SQL Worksheet/Editor
Advanced Content Assist
  • Content Assist is present in the Freeware version. However, upgrading allows you to configure its function
Editable result grid
  • Easily select any data that fits your requirements and modify its value right in the result grid
Export
Export to CSV
  • Export your entire table, selected rows or even query results to the universally used CSV format file
Schema Compare
  • This powerful tool makes database difference resolution significantly easier. You can:
    • Compare two different Schemas/Databases, even across two different database connections of the same platform and version
    • View all SQL code differences between two objects
    • Compare two objects with the same name based on their timestamps
    • Generate an HTML report detailing each and every difference found
    • Generate and deploy change scripts to automatically resolve the differences
Snapshots
  • By taking a snapshot of your database, you will be able to store its structure as a JSON file and use it as a backup or as a reference for Schema Compare
Versioning/Collaboration
Repository
  • This feature brings databases and version control systems together
  • Map your database to a file system and Toad Edge will transfer your database metadata to a folder structure populated with JSON files representing individual objects, referred to as a repository
  • Then, use any version control system to manage the repository
Automation
Continuous Integration/Continuous Delivery
  • Enhance your workflow by utilizing Toad Edge CI/CD features to perform periodic tasks with no manual input
  • Toad Edge is able to generate scripts and JAR files, which can be used by your automation server (such as Jenkins or TeamCity)
Other application features
Code snippets and templates
  • Create many code templates and then reuse them by invoking a specific custom keyword. This ability saves you a significant amount of effort in the long run
Session Browser
  • This view displays all current database sessions and is updated continuously. Observe all connected users and the states of their sessions while also being able to terminate any of them, assuming you possess the appropriate privileges
Feature comparison matrix
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

 

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