Share via

How can I compare the Original T-SQL Script with the edited version of the same T-SQL

Bobby P 231 Reputation points
2025-10-02T18:24:16.2066667+00:00

I thought Redgate and SQL Compare could compare two T-SQL scripts and highlight any changes, deltas for you...But I have no idea how to use that.

I also know that there are some one-off T-SQL comparison software packages out there. Which would the forum suggest is the best?

Hope I can get some help and guidance maybe on both fronts here.

Thanks in advance for your help.

SQL Server | SQL Server Transact-SQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
    2025-10-02T19:35:36.2233333+00:00

    If you want to compare scripts as such, you would use a plain compare tool. Myself, I use Beyond Compare from Scootersoft.

    If you want to compare the result of the two scripts, you would take a backup of the database and restore a copy and run one script on one copy, and the other script on the other copy. Then you can use SQL Compare to compare the copies.

    0 comments
  2. Joerg 62 196 Reputation points
    2025-10-02T21:37:36.2233333+00:00

    Another Software:

    https://diffuse.sourceforge.net/index_de.html

    Regards, Jörg

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.