Simple code to compair two databses within the same instance

To check things such as indexes, tables etc we can use this simple code to list the differences we have in the schemas.

select * from gipauth.dbo.sysindexes gip
where gip.name not in (select name from giptest.dbo.sysindexes)