New Feature to indicate the updates were successful

Sandy F.Sandy F. Posts: 7 Bronze 2
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!

Comments

  • 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
    David Atkinson
    Product Manager
    Redgate Software
  • 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
  • I agree, consistency with SQL Compare in this regard is important.

    Janez's idea makes sense to me as well.

    Thanks
    Alex Weatherall
    TeleWare.com
  • Sandy F.Sandy F. Posts: 7 Bronze 2
    This enhancement has been implemented many versions back.
Sign In or Register to comment.