About
- About DSP
- What We Do
- Leadership
- Resources
- Careers
Industries
Oracle Services
Microsoft Services
Resources
Contact

Toad for SQL Server

Product Highlights

Automation

Automate and schedule routine and repetitive processes, including data and schema comparisons to save time.

Development Productivity

Work more efficiently with advanced code completion, SQL formatting, and Script Map structured presentation of SQL scripts. Execute scripts against multiple servers and instances. Perform advanced SQL and T-SQL script debugging.

Database Administration

Undo or redo transactions stored in log files by reading online transaction logs, detached transaction log files, or log file backups for reconstructing transactions. Compare data between two databases, identify differences, and run or generate a script to synchronize.

Features

Database Objects

Browse, navigate, and manage database-specific objects like tables, views and roles.

Compare and synchronize

Easily identify differences by comparing and syncing servers, schemas and data. View comparison results and generate the change scripts needed to update the target environment.

Group execute

Process scripts and code snippets against multiple servers and instances.

T-SQL editing

Reduce the T-SQL learning curve, introduce consistency and help deliver high-quality code. Simplify SQL coding with advanced code complete, code snippets and SQL recall.

SQL Optimizer

Conduct application performance tuning with automated query rewrites and optimization.

Transaction log reader

Roll back transactions in the transaction log without restoring from a backup.

Security management

Create, manage and replicate security for all users by building and executing security-related scripts against multiple servers.

Additional Administration Assistance

Get additional health checks and other administration capabilities through the Database Admin module. Use Spotlight’s diagnostic aids to help determine root cause of performance issues. (Available with some editions.)