Universal Backup Database Enhancements: 2025-10-24

Universal Backup Database Enhancements: 2025-10-24

On 2025-10-24, the Universal Backup Database was Enhanced as Follows:
  1. Removed the Final_Extra_Content and Original_Extra_Content columns.
    1. Information that may have been stored in these columns now resides in the Source_Content columns.
Recent databases can be upgraded to the latest version by running the following script:

  2. DECLARE @SchemaName NVARCHAR(128);
  3. DECLARE @TableName NVARCHAR(128);
  4. DECLARE @ColumnName NVARCHAR(128);
  5. DECLARE @ConstraintName NVARCHAR(128);
  6. DECLARE @SQL NVARCHAR(MAX);

  8. -- Cursor to loop through dbo tables containing either of the two columns
  9. DECLARE DropCursor CURSOR FAST_FORWARD FOR
  10. SELECT 
  11.     s.name AS SchemaName,
  12.     t.name AS TableName,
  13.     c.name AS ColumnName
  14. FROM sys.columns c
  15. JOIN sys.tables t ON c.object_id = t.object_id
  16. JOIN sys.schemas s ON t.schema_id = s.schema_id
  17. WHERE c.name IN ('Original_Extra_Content', 'Final_Extra_Content')
  18.   AND s.name = 'dbo';  -- 🔹 Only dbo schema

  20. OPEN DropCursor;
  21. FETCH NEXT FROM DropCursor INTO @SchemaName, @TableName, @ColumnName;

  23. WHILE @@FETCH_STATUS = 0
  24. BEGIN
  25.     -- Find the default constraint (if any) for that column
  26.     SELECT 
  27.         @ConstraintName = dc.name
  28.     FROM sys.default_constraints dc
  29.     INNER JOIN sys.columns c ON dc.parent_object_id = c.object_id AND dc.parent_column_id = c.column_id
  30.     INNER JOIN sys.tables t ON c.object_id = t.object_id
  31.     INNER JOIN sys.schemas s ON t.schema_id = s.schema_id
  32.     WHERE c.name = @ColumnName
  33.       AND s.name = @SchemaName
  34.       AND t.name = @TableName;

  36.     -- Drop the default constraint if found
  37.     IF @ConstraintName IS NOT NULL
  38.     BEGIN
  39.         SET @SQL = N'ALTER TABLE [' + @SchemaName + '].[' + @TableName + '] DROP CONSTRAINT [' + @ConstraintName + '];';
  40.         PRINT @SQL;
  41.         EXEC sp_executesql @SQL;
  42.         SET @ConstraintName = NULL;
  43.     END

  45.     -- Drop the column itself
  46.     SET @SQL = N'ALTER TABLE [' + @SchemaName + '].[' + @TableName + '] DROP COLUMN [' + @ColumnName + '];';
  47.     PRINT @SQL;
  48.     EXEC sp_executesql @SQL;

  50.     FETCH NEXT FROM DropCursor INTO @SchemaName, @TableName, @ColumnName;
  51. END

  53. CLOSE DropCursor;
  54. DEALLOCATE DropCursor;


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

    • 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-05-02

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