New Feature to indicate the updates were successful

Sandy F.

Each SQL Compare script has this at the end...

@TRANCOUNT>0 BEGIN
PRINT 'The database update succeeded'
COMMIT TRANSACTION
END
ELSE PRINT 'The database update failed'
GO
DROP TABLE #tmpErrors
GO

I tell our off-shift computer operators to call me at home if they don't see the statement "The database update succeeded." Could this feature be added to SQL Data Compare? Sometimes I have them run critical data updates on off shifts and would like them to call only if there is a problem.

Thanks!

David Atkinson

Thanks, this really should be consistent with SQL Compare. I've put this in as an enhancement request (SDC-912). If anyone else needs this, please let us know as it will add weight to the request.

Kind regards,

David Atkinson
Red Gate Software

Janez

Hi,

I think even better would be to write out output for every table, for example:

Table1 (7 rows inserted, 5 rows updated, 2 rows deleted)
Table2 (22 rows inserted, 15 rows updated,4 rows deleted)
....
The database update succeeded

That would be even more consistent with SQL Compare which displays info on all actions accomplished during the execution of the script.

Janez

alex.weatherall

I agree, consistency with SQL Compare in this regard is important.

Janez's idea makes sense to me as well.

Thanks

Sandy F.

This enhancement has been implemented many versions back.