Compare data in rollback

[The-RUss]

I am using dB Forge data compare for some parallel testing. It really is a great tool.

Is it possible to run an exec procedure, compare the data, then roll it back?

[alexa]

Please note changes are not applied to a database before you run a generated synchronization script or perform synchronization straight into the database.

Also, after performing comparison, when setting up synchronization, you can select the 'Backup' option on the 'Options page' of the Data Synchronization Wizard dialog and 'Use a single transaction' option.

Please also refer to the following material for help http://www.devart.com/dbforge/sql/datac ... -more.html

[The-RUss]

I am not using this tool to sync data. I am only using it to review data.

I have sp in my software that process data and write the results to a table. I would like to run these sp in rollback and compare the data.

I was curious if you could add a query that would allow this

EXAMPLE:

BEGIN TRAN

EXEC XYZ_sp_Process 1000, TEST, Process, parameters

-- Db Forge captures the results

ROLLBACK TRAN

[alexa]

Since dbForge reads out data including the unclosed transactions, you can organize this on your own.