SQL Compare Red Gate

Question

SQL Compare Red Gate

89netanel

SSCrazy

Points: 2130
More actions
October 1, 2017 at 2:59 am

#350188

Hello,
Does SQL Compare by Red-Gate can show me if the syntax of Stored Procedure at one instance is different from same Stored Procedure on different instance?
Or it just compare if it exist on each instance?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

89netanel - Sunday, October 1, 2017 2:59 AM
Hello,
Does SQL Compare by Red-Gate can show me if the syntax of Stored Procedure at one instance is different from same Stored Procedure on different instance?
Or it just compare if it exist on each instance?

Yes it shows syntax differences also for procs, functions, views etc

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

89netanel - Sunday, October 1, 2017 2:59 AM
Hello,
Does SQL Compare by Red-Gate can show me if the syntax of Stored Procedure at one instance is different from same Stored Procedure on different instance?
Or it just compare if it exist on each instance?

As mentioned by Anthony, it shows differences at a granular level in a very clear way. If you can, I suggest you download and install it â€“ you'll be able to run in trial mode for a few days to test it out.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

SQL Compare will produce the CREATE syntax for both objects and then give you the differences as most Version Control Systems do. Here is a view of two different procs in two databases from SQL Compare:

Disclosure: I work for Redgate