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

Deploying only particular lines from stored procedures

edited November 28, 2014 3:48AM in SQL Compare 11
Is there a way to only mark particular lines to be deployed instead of having to deploy all changes to a stored procedure?

For instance, most source control software allows you to compare and merge hand picked differences and I was hoping that SQL Compare would have some feature that was similar?

I realise that you can quite easily right click on the comparison pane and select "Show Object Synchronization Script" and take out the lines you don't want (or edit them), but for larger changes it would help to only need to modify particular differences.


  • Options
    Eddie DEddie D Posts: 1,793 Rose Gold 5

    Thank you for your forum post.

    I believe what you are seeking cannot be achieved. The deployment script generated follows the Transact-SQL syntax conventions. Therefore when making changes to a procedure, an ALTER PROCEDURE command is used and SQL Compare will generate the script so that the deployment is successful.

    This msdn ARTICLE describes how to modify a stored procedure.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.