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
Tagged:

Best Answer

  • sam.blackburnsam.blackburn Posts: 224 Gold 2
    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.
    Software Developer
    Redgate Software

Answers

Sign In or Register to comment.