Skip to content
← dbForge Studio for SQL Server

How can we improve the product?

dbForge Studio for SQL Server: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Add Test mode for SQL

I used to work with Apex SQL where there was test mode. This is a very simple, but convenient feature. There was a button "Test Mode" beside the "Execute Script" button. The button had two states - pressed and unpressed. Clicking the button added two rows. "BEGIN TRANSACTION" was added at the beginning of the script and "ROLLBACK TRANSACTION" was added at the end. When unpressing the button, the two rows disappeared.

2 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Dan shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ryan Jorgensen commented  ·   ·  Report

    This would be useful, but I, personally, would prefer an alternative approach where there is a way to disable auto-commit mode. When auto-commit is turned off, your DML is always embedded in a transaction, without a commit or a rollback. Then, make it clear that there is an open transaction, and provide a commit and a rollback button. Many other tools provide this, and it's an important feature that's missing in dbForge Studio (in my opinion).