How do we compare a SQL Server Stored Procedure between two environments

ITBobbyP85

We have Redgate SQL Compare 13 Version 13.6.

We also have SQL Data Compare 13 Version 13.6

I get confused as to which Product to use when. Which product do I use to compare one SQL Server Stored Procedure between two environments and how do I provide the filtering criteria to just compare the one in question?

Are there any good YouTubes out there or any good web sites that walk you through? I am new to Redgate tools and am more or less on my own here to try and learn them on my own.

Any resources one could provide to learn these tools and how to utilize them would be GREATLY appreciated.

Thanks!

Mark R

SQL Compare is for comparing schema objects, so that's what you want for comparing stored procedures.

SQL Data Compare is for comparing data, ie the data in tables.

If you're looking for resources for learning how to use Redgate Tools, https://www.red-gate.com/hub/university/ is a good place to start.