How can we help you today? How can we help you today?

exclude certain keywords while comparing store procs

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
0

Comments

2 comments

Sort by
  • Brian Donahue
    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
    0
  • David Atkinson
    Another idea would be to create a copy of your database, rename getutcdate to getdate and compare this one instead.
    David Atkinson
    0

Add comment

Please sign in to leave a comment.