Thunderstone Support Forums

Have been using cpdb to convert database files to 64bit Texis so we can get passed the 2gb file size limit.

The issue is that the CPDB command drops after a table is copied. We have a lot of tables to convert and we were hoping to reduce down time as much as we can.

I was wondering if there is a way to convert all the tables in a batch possibily as an overnight job.

Which operating systems are you using? If both sides are the same you may be able to speed things up by using addtable -b 32 to add and convert a 32 bit file. Otherwise you can specify multiple tables to cpdb or have it transfer all tables in a single session.

We've got Windows 2000 on both servers. Texis on destination server is version 4 (64/32 bit). Should we copy the .tbl files to a local directory and then run addtable -b 32 command?

What is the sytax for supplying multiple tables with cpdb command?

Yes, you would copy the .tbl file where you want it, and then run addtable -b 32 <filename> in the database directory.

Give the -t option multiple times to specify multiple tables. If you don't use -t at all it will copy all tables in the database.