RE: Informix Migration
Plus, looks like you might be moving from 32-bit to 64-bit??
Check out Art Kagel's 'dbcopy' utility, which is in his utils2_ak package
at:
http://www.iiug.org/software/index_DBA.html
dbcopy works on a table-by-table basis, but you can copy multiple tables in
parallel. dbcopy is quite fast, without having to use intermediate
unload/load flat-files. I suggest that you create database and tables
*only* on target, copy over data via dbcopy, then create indexes,
constraints, etc. That's the strategy that I have used in the past.
HTH,
Paul Mosser
-----Original Message-----
From: Murray Wood (IList) [mailto:ifxmaillist@quanta.co.nz]
Sent: Tuesday, August 12, 2003 1:39 PM
To: informix-list@iiug.org
Subject: RE: Informix Migration
You can only restore to the same OS, same Informix version, so you cannot
restore an archive taken on AIX 4.3.3 to one on AIX 5.2
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Arnou Kunz (VSP)
> Sent: Tuesday, 12 August 2003 8:13 p.m.
> To: informix-list@iiug.org
> Subject: Informix Migration
>
>
>
> Hi there,
>
> We in the process to upgrade UNIX 4.3.3 and Informix 7.31 to UNIX 5.2
> and Informix 9.31.
>
> One of the first steps is to setup a complete development area,
> migrating 596750.00 meg of live data.
> The plan:
> Do a complete restore on a QA server, upgrade the QA server
> to Informix
> 9.31,
> not upgrading the operating system, do a onbar level 0 back to tape of
> the upgraded Informix server.
>
> Restoring the backup onto UNIX 5.2 Informix 9.31 migration server.
>
> This process will have to happen frequently to ensure that
> current data
> are used for testing.
>
> Will this work?
>
> Any other suggestions?
>
>
> Arnou Kunz
> Vodacom Service Provider
> IT and Billing
> Cell : +27 82 997 0631
> Tel : +27 11 546 1406
> Fax : +27 11 546 8366
> E-mail: arnouk@vodacom.co.za
> This e-mail is sent on the Terms and Conditions that can be
> accessed by Clicking on this link
> http://www.vodacom.net/legal/email.asp "
>
> sending to informix-list
sending to informix-list