Using cpdb to copy tables over the internet

Post Reply
barry.marcus
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Using cpdb to copy tables over the internet

Post by 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.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Using cpdb to copy tables over the internet

Post by 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
John Turnbull
Thunderstone Software
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Using cpdb to copy tables over the internet

Post by 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
Posts: 288
Joined: Thu Nov 16, 2006 1:05 pm

Using cpdb to copy tables over the internet

Post by barry.marcus »

Thanks. That worked perfectly!
Post Reply