Helen Borrie wrote:

> If you take the update route as recommended by Alan, it's not necessarily
> going to be a piece of cake. If you take the build-anew route recommended
> by Lester, with good data extraction and pumping tools, it will take longer
> but you have plenty of fall-back and can also log the causes of
> failures. But the dump-and-pump approach won't be practicable with very
> large databases if you're doing it often.

The UK postcode table at 400Mb can take a while to pump over :)
So it tends to get saved in the blank as we maintain it for all
customers anyway ;)
Also we tend to use external files rather than BLOB's and those
directories get zipped as part of a backup, which reduces the size of
the database somewhat.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services