The following errors appear on the screen when running compare with “nolockboth” option:
sp_ctrl >compare table owner.source_table to owner.target_table
target_server@o.target_SID nolockboth
Error: Unknown parameter or option: nolockboth
There is a syntax error in the command issued for compare.
The correct way to run the compare is:
sp_ctrl >compare table owner.source_table to owner.target_table target_server@o.target_SID –nolockboth
The option is “–nolockboth” and not “nolockboth”
