I'm trying to find a good open source tool that simply compares data in a database on one server to a table (of the same schema) on another server. Then I want to generate INSERT statements for the rows that are different, for either the source or destination/target table.
I've tried downloading several tools, and I can't get any of them to work because they all had bugs. I can be more specific with the errors I received if you need me to be.
TableDiffGui.zip SqlDiffFramework setup 126.96.36.199.exe SqlTableCompare.zip DaBCoS.0.3.2163.zip
If there is a manual way to do this, please let me know. My last resort will be to simply write a program that does it.