Convert to 64bit using CPDB

josmani · Post by **josmani** » Tue Jun 03, 2003 3:49 am

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.

Post by **John** » Tue Jun 03, 2003 9:04 am

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.

josmani · Post by **josmani** » Wed Jun 04, 2003 8:28 am

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?

Post by **John** » Wed Jun 04, 2003 9:11 am

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.