Will copy work if the referenced table does not exist on target?
Copy will work if the table being copied does not exist on the target. During the running of copy command the table will be created on target and also synchronized.
The steps involved are:
Start launcher process on target sp_ctrl:
sp_ctrl>start launcher
Then start copy on the source sp_ctrl:
sp_ctrl>copy OWNER.TABLE_NAME (assuming that the source and target tables are identical and the source table is replicating to one target)
There is no need to create a blank target table manually during the above.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center