Thursday, September 18, 2008

Compare schema between two databases

This is a bit rough, but the idea is to quickly find schema discrepancies between database1 and database2.
SELECT, l.type_desc,, m.type_desc
FROM database1.sys.objects as l
 full outer join database2.sys.objects as m on =
WHERE is null or is null

No comments:

Post a Comment