The copy command fails with the error “No tables to synchronize” as shown below:
sp_ctrl > copy master.config to dummy.config
No tables to synchronize
The table specified in the copy command is not a valid table.
Correct the copy command by providing valid table and schema name(s). The argument to the command should contain at a minimum the source schema and table name and can also include the target schema and table name. The latter is required if the schema and table name are different across source and target. Then re-issue the command. See Shareplex Reference Guide for detailed syntax of copy command.
The error also shows up if one is trying to make a copy of a config file and in the process omitted the keyword “config”. Shareplex then assumes that the command in question is “copy”. The correct syntax in this case would be:
sp_ctrl>copy config <config name> to <new config name>
The thing to remember is that the “copy” and “copy config” are two different commands. The former is for synchronizing the tables across source and target and the latter is for making a copy of a config file using sp_ctrl interface without having to use the OS editor. See Shareplex Reference Guide for detailed syntax of “copy config”.
