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

Is it possible to use SQL Compare to compare an existing SP with a SP sent as a file by a colleague

Hey,

As the title suggests, is it possible to compare a stored procedure on my database with a stored procedure sent to me by a colleague in a .sql file?

Cheers
Raynbag
0

Comments

2 comments

Sort by
  • sam.blackburn
    You could create a scripts folder using SQL Compare and then add (or replace) the procedure inside it.  However, Compare can have some unpredictable behaviour if you cause the scripts folder to be inconsistent, for example by referencing nonexistent objects from your procedure.
    sam.blackburn
    0
  • Raynag
    Brilliant, thank you for the quick response, much appreciated.
    Raynag
    0

Add comment

Please sign in to leave a comment.