Quickly Finding Missing Objects in Two SQL Server 2005 Databases

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

 

Leave a Comment

Your email address will not be published. Required fields are marked *