Using cpdb to copy tables over the internet

[barry.marcus]

Is it possible to copy tables to a Texis DB over the internet using cpdb? If so, what is the proper syntax? On the remote server cpdb is running in server mode, and on the "local" machine I've been trying things like:

cpdb -d D:\MyDBDir -h www.remotehost.com:1234 -r D:\TargetDBDir -t MyTable -p

This doesn't work and I'm wondering if I'm trying to get cpdb to do something it's not designed to do.

Thanks.

[John]

That's almost correct, how did you start the remote cpdb?

There shouldn't be the :1234 on the end of the remotehost, if you want to use a different port specify it with -P, e.g. if on the remote side you ran:

cpdb -P 1234

then on the localside:

cpdb -d D:\MyDBDir -h www.remotehost.com -P 1234 -r D:\TargetDBDir -t MyTable -p

[mark]

Yes.

http://www.thunderstone.com/site/texisman/cpdb.html

Use the -P option to specify a non-standard port instead of tacking it on the end of the hostname.

Make sure any firewalls between client and server allow connection between those machines on the desired port, default 10004.

[barry.marcus]

Thanks. That worked perfectly!