Command line not detecting differences
JohnStevensBI
Posts: 9
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.
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?
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?
Comments
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!
Technical Sales Engineer
Redgate Software