Universal Backup Database Enhancements: 2024-11-21

Universal Backup Database Enhancements: 2024-11-21

On 2024-11-21, the Universal Backup Database was Enhanced as Follows:
  1. Added "Subject" columns to Time, Expenses, and Fees
Recent databases can be upgraded to the latest version by running the following script:

  2. ALTER TABLE __M_Financial_Activities_Expenses  ADD Final_Subject    NVARCHAR(MAX) NOT NULL DEFAULT('');
    ALTER TABLE __M_Financial_Activities_Expenses  ADD Original_Subject  NVARCHAR(MAX) NOT NULL DEFAULT('');
    ALTER TABLE __M_Financial_Activities_Time    ADD Final_Subject    NVARCHAR(MAX) NOT NULL DEFAULT('');
    ALTER TABLE __M_Financial_Activities_Time    ADD Original_Subject  NVARCHAR(MAX) NOT NULL DEFAULT('');
    ALTER TABLE __M_Financial_Activities_Fees    ADD Final_Subject    NVARCHAR(MAX) NOT NULL DEFAULT('');
    ALTER TABLE __M_Financial_Activities_Fees    ADD Original_Subject  NVARCHAR(MAX) NOT NULL DEFAULT('');


    • Related Articles

    • Universal Backup Database Enhancements: 2024-09-02

      On 2024-09-02, the Universal Backup Database was Enhanced as Follows: Added Action_Priority column to all tables Recent databases can be upgraded to the latest version by running the following script: EXEC sp_MSforeachtable ' ALTER TABLE ? ADD ...

    • Universal Backup Database Enhancements: 2024-09-18

      On 2024-09-18, the Universal Backup Database was Enhanced as Follows: Renamed *_Role column on __M_Matters_Participating_Entities to *_Participant_Role Recent databases can be upgraded to the latest version by running the following script: exec ...

    • 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: 2025-10-24

      On 2025-10-24, the Universal Backup Database was Enhanced as Follows: Removed the Final_Extra_Content and Original_Extra_Content columns. Information that may have been stored in these columns now resides in the Source_Content columns. Recent ...

    • Universal Migrator Update: 2025-04-01

      If you have a Universal Backup database from a previous version of Universal Migrator, you will need to upgrade it by following the Delta Migration Procedure. New Backup Tools Universal Migrator now includes Backup options for the following ...