How can we help you today? How can we help you today?

New Feature to indicate the updates were successful

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!
Sandy F.
0

Comments

4 comments

Sort by
  • 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
    David Atkinson
    0
  • 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
    Janez
    0
  • alex.weatherall
    I agree, consistency with SQL Compare in this regard is important.

    Janez's idea makes sense to me as well.

    Thanks
    alex.weatherall
    0
  • Sandy F.
    This enhancement has been implemented many versions back.
    Sandy F.
    0

Add comment

Please sign in to leave a comment.