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

      Universal Migrator has three types of logs that you can use to investigate the results of a data extraction or injection. 1. Output Logs Output logs are stored in: %LocalAppData%\Universal Migrator\__Diagnostics\Logs and captures user-visible text ...

    • Repair a corrupt MSSQL database

      For law firms with premises based systems like Time Matters you may run into situations where the database has not been maintained and has become inconsistent. This can prevent your ability to create a backup from which you can migrate the customer ...

    • Create a POSTGRES Backup

      This article assumes that you know your Postgres credentials and PgAdmin is Installed. Connect into PgAdmin. Right-Click on the database and click Backup Click on the folder icon to choose a location for your backup When you reach the location to ...