exclude certain keywords while comparing store procs

Forum for users of SQL Compare schema synchronization utility

exclude certain keywords while comparing store procs

Postby touqeera » Tue Aug 05, 2014 3:40 am

I was trying to compare the store procs from two dbs, and I knew one difference was getutcdate() instead of getdate(). I wanted to see only those store procs which have any difference(s) other than getutcdate(), I tried to search in sql compare if I can achieve that, no luck.

can anyone please point to the right direction? thanks
Posts: 1
Joined: Tue Aug 05, 2014 3:32 am

Postby Brian Donahue » Thu Aug 07, 2014 12:44 pm

SQL Compare can compare the creation text of SQL Server stored procedures. The options you can set for that are to filter them out completely by object name, ignore whitespace and comments, or remap the schema or owner names. Unfortunately there are no complex rules you can apply to the comparison of the text, such as ignoring all differences where a certain function is used inside the stored procedure.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby David Atkinson » Thu Aug 07, 2014 12:58 pm

Another idea would be to create a copy of your database, rename getutcdate to getdate and compare this one instead.
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests