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 4: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
touqeera
 
Posts: 1
Joined: Tue Aug 05, 2014 4:32 am

Postby Brian Donahue » Thu Aug 07, 2014 1: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 10:48 am

Postby David Atkinson » Thu Aug 07, 2014 1: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: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests