Page 1 of 1

cpdb

Posted: Wed May 02, 2001 4:46 pm
by MiniMe
I have a Texis NT box and an ALPHA running Tru64. I am trying to use cpdb to copy the table structures from Tru64 to NT. On the NT box I run cpdb -v on the Tru64 box I run 'cpdb -d /db/tables/prod -h 172.16.1.236 -t customer.tbl -p'. after about 2 seconds the cpdb on the Tru64 box core dumps and the cpdb on the NT box dies with a '200 Command: SET' as the only output. Any advice.

cpdb

Posted: Wed May 02, 2001 4:59 pm
by John
You should run the cpdb without any arguments on the NT machine. On the TRU64 machine the -t option does not use the .tbl extension, it takes the name of the table as known to Texis. Also you need to specify -r and the database name you want to use on the NT machine, e.g.:

cpdb -d /db/tables/prod -h 172.16.1.236 -r c:/db/tables/prod -t customer -p

cpdb

Posted: Wed May 02, 2001 5:03 pm
by MiniMe
Well that sort of fixes it.. if the table already exists on NT it abends the cpdb. So if I script the 300+ tables and it hits one that exists then it fries the daemon.. I guess I can work around that unless you have any more suggestions.

cpdb

Posted: Wed May 02, 2001 7:28 pm
by John
It shouldn't abend, which we'll look into, however cpdb will not copy a table if it already exists at the destination.