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