About upgrading

How to check when and to what versions the software and database versions were upgraded. What database query should I make? I need to get the whole history of updates made.

  • Hi  

    There is no such history of the number of upgrades which might be done on your existing Safeguard Server and database. You can find out the last update date and target version (which also represents the current DB version) using this query:

    SELECT [TIF_TABLE_NAME]

               ,[TIF_VERSION]

               ,[TIF_MODIFY_DATE]

               ,[TIF_CREATED_BY]

               ,[TIF_MODIFIED_BY]

       FROM [SafeGuard].[dbo].[TABLE_INFO] where TIF_TABLE_NAME = 'TABLE_INFO'

    I hope this will help bit to know the last version from you upgraded.

     

  • In reply to Jasmin:

    It is a pity that such information cannot be drawn. Thank you for your answer.