Data compare command line not working for different table names
So running into one wall after another. I have managed to get this to run when both tables have the same name but cannot get it to work when the names are different even when using the /include:different switch. Keeps flagging up 'invalid key - only one can be specified'. When I change the option to identical and change the table names to both the same, it works. What am I missing here?
"C:\Program Files (x86)\Red Gate\SQL Data Compare 14\SQLDataCompare.exe" /s1:svr /s2:svr /db1:redgate_Src /db2:redgate_trg /Include:table /Include:table:tableA^|TableB /IncludeColumns:TableA:\[edition_id\] /ComparisonKeys:TableA:PKDC002RHEditionsDatesSrcIndex /v /Include:DIFFERENT