USE dbc1!table
COPY TO \app\production\data2\table DATABASE \app\production\data2\dbc2 WITH CDX
The keyword DATABASE and the target database are all that are needed. Also can use the NAME keyword after DATABASE to give it the long database name if different.
One note. Primary keys will be copied as candidate and have to be manually reset in the new database.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
