Possibilities with SQL Data Compare
Compare two tables on a daily basis. They are placed in a separate databases together with a lot of other tables but they do not have the same name. The data structure is almost the same and they have a columns where they can match rows on.
Would that be possible to do with this tool and if yes how would you set this up so you in a command line. You would need to provide the table names. The key columns to match rows on is static so maybe that could be configured in a project?
It looks a bit to me as this tool is mainly designed to compare whole databases, but maybe I am wrong?