Move temp/backup objects to Deprecated schema

move-deprecated-objects.sql

IF (SCHEMA_ID('Deprecated') IS NULL)
    EXEC('CREATE SCHEMA [Deprecated];');

SELECT 'ALTER SCHEMA [Deprecated] TRANSFER '+QUOTENAME(OBJECT_SCHEMA_NAME([object_id]))+'.'+QUOTENAME(OBJECT_NAME([object_id]))+';'
FROM sys.objects
WHERE [schema_id] NOT IN (SCHEMA_ID('Deprecated'), SCHEMA_ID('sys'))
  AND [type] NOT IN ('PK', 'F', 'D', 'UQ')
  AND ([name] LIKE '%xx%' OR [name] LIKE '%[0-9][0-9][0-9][0-9][0-9][0-9]%'
    OR [name] LIKE '%[ _]temp' OR [name] LIKE 'temp[ _]%'
    OR [name] LIKE '%[ _]old' OR [name] LIKE 'old[ _]%'
    OR [name] LIKE '%backup' OR [name] LIKE 'backup%')
ORDER BY OBJECT_SCHEMA_NAME([object_id]), OBJECT_NAME([object_id]);