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:
- Tell me schema differences
- 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:
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):
- Command Line
- Self Contained
- Compare Schema
- Compare Data
All pointers greatly appreciated.