I have posted this question before and while the solution posted works I am still on the hunt for a simple command line (don't need a GUI as this is for automation purposes) utility that does 2 basic things:

  1. Tell me schema differences
  2. Tell me data differences

While there are MANY SO posts (and I have read them all) on the subject most of them either list commercial tools (RedGate in particular) or are very old posts (like 7+ years old) and the software does not exist.

There are a couple of interesting Microsoft solutions to this:

  1. TableDiff
  2. VsDBCmd.exe

The issues with TableDiff are that it was built for replication so even though the tables are identical in schema it will report even if the columns are in a DIFFERENT order - it was meant for low level stuff. So hence heaps of false positives.

VsDBCmd requires an installation of Visual Studio on the machine doing the comparison. As this is for CI automation purposes this is not a solution in my case. I want something simple and self contained.

So has anyone got any tool that they have seen or can recommend that can do the basics (as stated above):

  • Free
  • Command Line
  • Self Contained
  • Compare Schema
  • Compare Data

All pointers greatly appreciated.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.