Debugger

Last modified: September 6, 2024

The Debugger functionality of dbForge Studios is an invaluable tool for developers working with stored procedures, functions, triggers, and complex SQL scripts. It enables users to step through and debug database code, set breakpoints, inspect variables, and troubleshoot SQL queries, ensuring the reliability and performance of database routines.

To debug stored procedures, you need the following permissions:

  • ALTER TRACE permission on the server.
  • VIEW SERVER STATE permission on the server.
  • DEBUGGER role membership in the database.

For more information about the debugging capabilities and requirements to start the Debugger, see Debugger overview for dbForge Studio for MySQL and see Debugger overview for dbForge Studio for SQL Server.

Debugger SQL Server MySQL and MariaDB Oracle        PostgreSQL
Script debugging YES YES YES NO
Step Into, Step Over, and Step Out commands for step-by-step execution YES YES YES NO
Breakpoints for procedures, functions, triggers, and scripts YES YES YES NO
Breakpoints window YES YES YES NO
Call Stack window with navigation YES YES YES NO
Watches window for the evaluation of variables YES YES YES NO

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Edge.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

dbForge Edge logo

Ready to start using  

dbForge Edge?

Download a FREE 30-day trial