--表名不一样
SELECT TABLE_NAME
FROM TEMP1.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_NAME NOT IN (SELECT TABLE_NAME
                         FROM TEMP2.INFORMATION_SCHEMA.TABLES
                         WHERE TABLE_TYPE = 'BASE TABLE')

--表结构不一样
SELECT TEMP1.DBO.SYSOBJECTS.NAME AS TABLE_NAME,
       TEMP1.DBO.SYSCOLUMNS.NAME AS COLUMN_NAME
FROM TEMP1.DBO.SYSCOLUMNS
INNER JOIN TEMP1.DBO.SYSOBJECTS
ON TEMP1.DBO.SYSCOLUMNS.ID = TEMP1.DBO.SYSOBJECTS.ID
WHERE (TEMP1.DBO.SYSOBJECTS.XTYPE = 'u')
AND (NOT (TEMP1.DBO.SYSOBJECTS.NAME LIKE 'dtproperties'))

------解决方案--------------------
右键数据库--任务--生成脚本