Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
The "copy table" or "append table" with "force" option results in error "Specify correct target tablename"
Description
copy table command is issued to copy a source table in replication to the target table, though the source table is not replicating to the target table specified in copy command. The copy table errors out as below:
sp_ctrl (source_server:port_num) > copy owner.TABLE1 to owner.TABLE1 force
Cannot copy "OWNER"."TABLE1" Table "OWNER"."TABLE1" is in replication, but not to tablename specified Specify correct target tablename or use the force option to copy
The config file illustrates the fact that the source table is replicating to a table other than the one specified in the copy table:
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.