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: 113445 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: 246686 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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Steve Jones - SSC Editor SSC Guru Points: 734418 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