Two databases compare view stored procedures and table structure differences

Two databases compare view stored procedures and table structure differences

Comparison of views and stored procedures

The principle uses the system table "sysobjects" and the system table "syscomments" to compare views and stored procedures in the database. system table "sysobjects" before a detailed introduction, interested to see: SQL Server System table sysobjects introduction and use

Code

/*--calls the example exec p_compdb ' DBNAME1 ', ' DBNAME2 ' exec p_compdb ' DBNAME2 ', ' DBNAME3 '--*/CREATE proc p_compdb @db1 sysname, First library @db2 sysname--second library as EXEC (' Select Type =case isnull (a.xtype,b.xtype) when ' V ' ' Then ' view ' ' else ' ' stored procedure ' end , match =case a.name is null then ' library [' + @db1 + '] without ' when b.name is null then ' ' Library [' + @db2 + '] in none ' Else '