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:

  1. 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-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: 2024-09-02

      On 2024-09-02, the Universal Backup Database was Enhanced as Follows: Added Batch_Group 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 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 ...
    • Universal Migrator Update: 2025-04-26

      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 ...
    • Universal Migrator Update: 2025-01-18

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