Re: Migrating/upgrading from 7.3.3 to 8.0.5

Ken,
Personally, if the table layout remains unchanged, just Indexes and Sizing changing, I would go for an Export / Import approach. Otherwise, I would suggest tests to verify which is the easiest way to complete the modification.

Also, Have you got a test environment that you can rehearse in?

Andrew

Ken White wrote:

> We have a 4GB database that we are planning to migrate from 7.3.3 to 8.0.5.
> At the same time there are a number of database structural changes that also
> have to be implemented. As some of the tables contain several hundred
> thousand rows I am trying to work out the quickest way to do this. I can
> create new correctly sized 8.0.5 database for the new DB structure. To move
> the data from the old database to the new database, will it be quicker to
> use a dblink and just copy the rows (insert into... select ... or perhaps
> using SQL+ copy) or would I be better off creating loader input files and
> using the loader to do this?
>
> Any thoughts appreciated
> Ken White
Received on Tue Apr 27 1999 - 03:08:02 CDT