Universal Backup Database Enhancements: 2026-05-28

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:

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

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

  24. IF NOT EXISTS (
  25.     SELECT 1
  26.     FROM INFORMATION_SCHEMA.COLUMNS
  27.     WHERE TABLE_NAME = '__M_Common_Addresses_Email'
  28.       AND COLUMN_NAME = 'Original_Description'
  29. )
  30. BEGIN
  31.     ALTER TABLE __M_Common_Addresses_Email
  32.         ADD Original_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  33. END

  35. IF NOT EXISTS (
  36.     SELECT 1
  37.     FROM INFORMATION_SCHEMA.COLUMNS
  38.     WHERE TABLE_NAME = '__M_Common_Addresses_Phone'
  39.       AND COLUMN_NAME = 'Final_Description'
  40. )
  41. BEGIN
  42.     ALTER TABLE __M_Common_Addresses_Phone
  43.         ADD Final_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  44. END

  46. IF NOT EXISTS (
  47.     SELECT 1
  48.     FROM INFORMATION_SCHEMA.COLUMNS
  49.     WHERE TABLE_NAME = '__M_Common_Addresses_Phone'
  50.       AND COLUMN_NAME = 'Original_Description'
  51. )
  52. BEGIN
  53.     ALTER TABLE __M_Common_Addresses_Phone
  54.         ADD Original_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  55. END

  57. IF NOT EXISTS (
  58.     SELECT 1
  59.     FROM INFORMATION_SCHEMA.COLUMNS
  60.     WHERE TABLE_NAME = '__M_Common_Addresses_Postal'
  61.       AND COLUMN_NAME = 'Final_Description'
  62. )
  63. BEGIN
  64.     ALTER TABLE __M_Common_Addresses_Postal
  65.         ADD Final_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  66. END

  68. IF NOT EXISTS (
  69.     SELECT 1
  70.     FROM INFORMATION_SCHEMA.COLUMNS
  71.     WHERE TABLE_NAME = '__M_Common_Addresses_Postal'
  72.       AND COLUMN_NAME = 'Original_Description'
  73. )
  74. BEGIN
  75.     ALTER TABLE __M_Common_Addresses_Postal
  76.         ADD Original_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  77. END

  79. IF NOT EXISTS (
  80.     SELECT 1
  81.     FROM INFORMATION_SCHEMA.COLUMNS
  82.     WHERE TABLE_NAME = '__M_Common_Addresses_SocialMedia'
  83.       AND COLUMN_NAME = 'Final_Description'
  84. )
  85. BEGIN
  86.     ALTER TABLE __M_Common_Addresses_SocialMedia
  87.         ADD Final_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  88. END

  90. IF NOT EXISTS (
  91.     SELECT 1
  92.     FROM INFORMATION_SCHEMA.COLUMNS
  93.     WHERE TABLE_NAME = '__M_Common_Addresses_SocialMedia'
  94.       AND COLUMN_NAME = 'Original_Description'
  95. )
  96. BEGIN
  97.     ALTER TABLE __M_Common_Addresses_SocialMedia
  98.         ADD Original_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  99. END

  101. IF NOT EXISTS (
  102.     SELECT 1
  103.     FROM INFORMATION_SCHEMA.COLUMNS
  104.     WHERE TABLE_NAME = '__M_Common_Addresses_WebSite'
  105.       AND COLUMN_NAME = 'Final_Description'
  106. )
  107. BEGIN
  108.     ALTER TABLE __M_Common_Addresses_WebSite
  109.         ADD Final_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  110. END

  112. IF NOT EXISTS (
  113.     SELECT 1
  114.     FROM INFORMATION_SCHEMA.COLUMNS
  115.     WHERE TABLE_NAME = '__M_Common_Addresses_WebSite'
  116.       AND COLUMN_NAME = 'Original_Description'
  117. )
  118. BEGIN
  119.     ALTER TABLE __M_Common_Addresses_WebSite
  120.         ADD Original_Description NVARCHAR(MAX) NOT NULL DEFAULT('')
  121. END

  123. IF NOT EXISTS (
  124.     SELECT 1
  125.     FROM INFORMATION_SCHEMA.COLUMNS
  126.     WHERE TABLE_NAME = '__M_Matters_Stages'
  127.       AND COLUMN_NAME = 'Original_ParentPracticeArea_Id'
  128. )
  129. BEGIN
  130.     ALTER TABLE __M_Matters_Stages
  131.         ADD Original_ParentPracticeArea_Id NVARCHAR(MAX) NOT NULL DEFAULT('')
  132. 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-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: IF NOT EXISTS ( SELECT 1 FROM ...

    • 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 ...

    • 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 ...