SQL Server Schema Transfer

-- Schema Transfer

SELECT 'ALTER SCHEMA Testing TRANSFER HumanResources.'+name
FROM sys.objects
WHERE type IN ('U','V','P','Fn')
AND SCHEMA_NAME(SCHEMA_ID) = 'HumanResources'