Command line not detecting differences

JohnStevensBI

My command line script, shown below, does not detect differences between two tables that have different data sets. Specifically, the table on server1 has more rows than its counterpart on server2.

sqldatacompare /Server1 server1 /Server2 server2 /db1:dbname /db2:dbname /UserName2:sqluser /Password2:password /Synchronize /Options:n /Include:Table:tablename

I have tried this with option /ucc as well, and by stating the tablename as [tablename]
I have tried it with /Include:Identical, which successfully surpresses the error.

What are the troubleshooting steps?

Andrew P

Hey John,

Thanks for posting to the forums!

I have followed up with you via email to resolve this issue. I believe we need to adjust your script - here is a good article on using the command line with the include statement https://documentation.red-gate.com/disp ... comparison

Thanks!