Real quick I wanted to know what tables and stored procs were in my ReleaseManagerTest database and not in my ReleaseManager database. So here is the SQL for that.
select min(DB) as DB, name, type
from
(
select 'ReleaseManagerTest' as DB, name, type
from ReleaseManagerTest.sys.objects
union all
select 'ReleaseManager' as DB, name, type
from ReleaseManager.sys.objects
) A
group by name, type
having count(*) <> 2
select min(DB) as DB, name, type
from
(
select 'ReleaseManagerTest' as DB, name, type
from ReleaseManagerTest.sys.objects
union all
select 'ReleaseManager' as DB, name, type
from ReleaseManager.sys.objects
) A
group by name, type
having count(*) <> 2