What are the challenges you face when working across database platforms? Take the survey

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


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?


Best Answer

  • Options
    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


Sign In or Register to comment.