Migrating and Upgrading to Informix 14 in-house or in the cloud. The easy and the hard way. by Lester Knutsen. There are several easy procedures to upgrade and migrate Informix. We will look at the easy way (in-place upgrades, dbexport, cdr migrate, backup/restore), but sometimes they may not work for you, and you need to create a custom process. We will go over a set of procedures and scripts using HPL, external tables, and parallel unloads/loads that I have used over the last few years to migrate from small systems up through terabyte-sized databases to VMs, new hardware, and the cloud.

At some point, every system gets outdated or starts showing its age. We all have had to deal with the headaches and logistical nightmares of moving our core databases from a legacy system on to a new server. In this webcast, we will cover different ways in which you can leverage Informix Enterprise Replication to move from an old server to a new one with minimal downtime, headache, and infrastructure needed. We will be covering cases of needing to handle the potential for fail backs, migrating between different OS platforms, as well as covering ideas to minimize end user interruption.

The second part of this webcast will further examine the Informix utilities which can be used to migrate data to a new system, and how to combine different utilities to speed up migrations and minimize downtime.

Migrating your Informix databases to new hardware and operating systems can be a daunting task. During this webcast, we will look at some of the challenges involved, and things to consider when migrating. We will look at the various tools available in Informix which can be used to unload and load data and cover the use of dbexport and dbimport.