Binary dump and load - compatibility?

[zsiadat]

Hi,

We're migrating a database from version 9 to 10 on one machine to another, and as of yet we have been utilizing ASCII dump and load to achieve this. Unfortunately (or perhaps fortunately?) our database has grown rapidly in size, thus making this procedure extremely time consuming. This has created somewhat of an issue to us. My question is therefore: is it possible to successfully do a binary dump on a database running version 9, and then binary load that data on a database running version 10?

Thanks,
zsiadat

 

[TomBascom]

Yes.

Although binary isn't always radically faster than ascii.

The most significant improvements in the speed of a dump & load come from parallelizing the process:

http://www.greenfieldtech.com/downloads/downloads.shtml

Exch06db8.ppt & dl.tar might be useful to you.

 

[zsiadat]

Cool. The dump & load worked out just fine. I have, however, been parallelizing the load in order to increase performance.

Thank you for your help, it was very useful!

/zsiadat