Chat now with support
Chat with Support

Toad Edge 2.9 - User Guide

Snapshots

In Toad Edge, snapshots are a way of storing database structure (without data) as a readable JSON file. This file can be subsequently used as a create script source or as a Schema Compare source/target in Continuous Integration and Delivery (CI/CD).

There is also another type of snapshot - baseline snapshot. It is nearly identical to regular snapshot except it can be used in CI/CD in the Compare database with baseline build step. This build step will return an error if the database is different from the baseline snapshot. See Continuous Integration and Delivery Wizard for more information.

To take a snapshot of a database

  1. In Object Explorer, right-click any database and select Take Snapshot
  2. Change the snapshot name if you wish. Then click OK

Snapshots are stored in the Toad Edge folder structure. You can access the snapshot files in Snapshots View.

Templates

Templates are script snippets that can be reused in various editors. In Toad Edge, templates can be defined in three contexts:

To configure templates

  1. Go to Preferences (View menu | Preferences or press ALT + P)
  2. Switch to the Templates tab. Here you can add/edit/remove templates

TIP: You can use variables in the code of your templates by typing ${variableName}. If you need to enter a literal dollar symbol, enter two dollar characters in sequence $$.
When a template is used, its variables can be quickly set to specific values. You can also jump between the variables by pressing TAB and SHIFT + TAB.

Run SQL file

Toad Edge supports direct SQL script operation without opening script in the worksheet. Select the connection from the drop-up menu on which you want to run the script. Select the SQL script file and set the log location to run the SQL file directly.

Run SQL File can be displayed two ways.

  • It gets triggered when trying to open a large script file(>3mb)
  • Manually by selecting File -> Run SQL File

User Privilege Managements

The subsections below explain the various user privilege views provided by Toad Edge® and their management w.r.t to an object or an user.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating