It seems AdeptSQL Diff is not compatible with SQL Server 2012 (at this time). And it is my preferred tool for deploying changes. I realize this is a shopping list but I hope SE won't mind.

I am wondering what are the best alternatives out there and wanted to query the DBAs.

Currently I am evaluating RedGate SQL Compare. It doesn't include data comparison (separate product) though it does generate deployment scripts which is nice. Just want something quick and painless for launching schema changes to production servers. What do you recommend. Thanks!

  • 2
    Redgate compare = schema, data compare = data. I highly recommend both. Sep 10, 2012 at 20:39

2 Answers 2


ApexSQL Diff supports SQL Server 2012. Haven't tested it on SQL Server 2012, but it works fine on 2008


Advancor Database Compare is a great tool and supports SQL Server 2016.

  • I'm sorry but, it is not available today as I seen in its web site: The "Company is closing for business"
    – Asereware
    Jan 27, 2020 at 19:35

Not the answer you're looking for? Browse other questions tagged or ask your own question.