Introduction
Connect
Create Amazon Redshift Connections
Create ODBC Connections
Create Oracle Connections
Create Snowflake Connections
Create SQL Server Connections
Create SharePoint Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Automate
Compare Differences in Files
Use the Diff Viewer to compare differences between DDL and other files. The Diff Viewer supports the following file types:
|
C# (.cs) |
Javascript (.js) |
Visual Basic (.vb) |
|
Cascading style sheets (.css) |
Perl (.pl) |
Visual Basic script (.vbs) |
|
DDL |
PHP (.php) |
XML documents (.xml) |
|
DOS batch (.bat) |
Python (.py) |
XML schema definition (.xsd) |
|
HTML (.htm, .html) |
SQL (.sql) |
|
|
Java (.java) |
Text (.txt) |
|
To compare differences
-
Right-click an object in the Object Explorer and select Send To | Diff Viewer as Script.
-
Use the Diff Viewer toolbar to view any differences.
Tips:
- To switch the contents of the left pane to the right pane, and the contents of the right pane to the left, click
.
- You can also open files to compare by clicking
beside the drop-down list at the top of each pane.
- Toad allows to modify files in the Diff Viewer.
- To switch the contents of the left pane to the right pane, and the contents of the right pane to the left, click