exclude certain keywords while comparing store procs

touqeeratouqeera Posts: 2
edited August 7, 2014 8:58AM in SQL Compare Previous Versions
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
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,460 Rose Gold 2
    Another idea would be to create a copy of your database, rename getutcdate to getdate and compare this one instead.
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.