Page 1 of 1

copydb and cpdb

Posted: Wed Dec 05, 2001 5:30 pm
by skalyanaraman
Hi,
I have successfully used copydb before to move a table from NT to UNIX. It was fine. Now I am trying to use on a different database/table and it does not give any errors but the last 8 or 9 fields were not even created. The table is there with the data in it but the last 8 or 9 fields missing. Any ideas?

I thought of using cpdb instead but if I run cpdb with no parameters from UNIX I get the error,

000 bind: Address already in use in the function ezserversock

Is it because texisd is already running, which it is.

Any help is greatly appreciated. thanks

copydb and cpdb

Posted: Wed Dec 05, 2001 6:15 pm
by John
We'd need to know the table structure to try and figure out why some fields weren't making it. The address already in use suggests that cpdb is already running, or something else is using the same port. Cpdb and texisd use different ports.

copydb and cpdb

Posted: Wed Dec 05, 2001 6:17 pm
by skalyanaraman
Interestingly, I created the table first on UNIX and tried the copydb and I got the following errors,

000 SQLExecute() failed with -1 in the function: execntexis
000 Insufficient values for fields in the function: Insert

The structure is quite big. Do you want me to send it to you via email?

thanks for the help.

copydb and cpdb

Posted: Wed Dec 05, 2001 9:54 pm
by John
Yes, it might be better to open a ticket by emailing support@thunderstone.com