Universal Backup Database Enhancements: 2026-07-14

Universal Backup Database Enhancements: 2026-07-14

On 2026-07-14, the Universal Backup Database was slightly changed add a few additional columns to certain tables:
Recent databases can be upgraded to the latest version by running the following script:

  2. IF NOT EXISTS (
  3.     SELECT 1
  4.     FROM INFORMATION_SCHEMA.COLUMNS
  5.     WHERE TABLE_NAME = '__M_Users'
  6.       AND COLUMN_NAME = 'Final_Kind'
  7. )
  8. BEGIN
  9.     ALTER TABLE __M_Users
  10.         ADD Final_Kind NVARCHAR(MAX) NOT NULL DEFAULT('')
  11. END

  13. IF NOT EXISTS (
  14.     SELECT 1
  15.     FROM INFORMATION_SCHEMA.COLUMNS
  16.     WHERE TABLE_NAME = '__M_Users'
  17.       AND COLUMN_NAME = 'Original_Kind'
  18. )
  19. BEGIN
  20.     ALTER TABLE __M_Users
  21.         ADD Original_Kind NVARCHAR(MAX) NOT NULL DEFAULT('')
  22. END


    • Related Articles

    • Universal Backup Database Enhancements: 2026-03-15

      On 2026-03-15, the Universal Backup Database was slightly changed to standardize the name of the Logs table. Recent databases can be upgraded to the latest version by running the following script: EXEC sp_rename 'dbo.__B_LOGS', '__B_Logs';

    • Universal Backup Database Enhancements: 2026-02-16

      On 2026-02-16, the Universal Backup Database was enhanced with expanded logging capabilities. Recent databases can be upgraded to the latest version by running the following script: EXEC sp_MSforeachtable ' ALTER TABLE ? ADD Log_Updated_At ...

    • Universal Backup Database Enhancements: 2026-05-28

      On 2026-05-28, the Universal Backup Database was slightly changed add a few additional columns to certain tables: Recent databases can be upgraded to the latest version by running the following script: IF NOT EXISTS ( SELECT 1 FROM ...

    • Backup (Pull) Connectors: Development and Enhancement Requests

      A backup/pull connector allows Universal Migrator to connect to source systems and backup/extract the data out. Backup Connector Requirements Whether you are requesting a brand new backup connector or enhancements to an existing one, the following ...

    • Connecting Universal Migrator to an InterSystems Cache Database

      When connecting Universal Migrator to a Cache' database/namespace, you will need to enter the following information into the "Original Data" screen: Choose "in InterSystems Cache'" as the source. For the server name, put the IP address of the Cache ...