IDS Forum

Re: Migrating data between Informix Platforms with

Posted By: Art S. Kagel (Oninit LLC)
Date: Tuesday, 27 November 2007, at 1:42 p.m.

In Response To: Migrating data between Informix Platforms without (Jonathan Smaby)

Jonathan Smaby wrote:
> Good morning,
>

Bob Roussey's comments aren't far off. Utils2_ak doesn't do EVERYTHING,
but it's highly useful and does have features for your needs. In
utils2_ak you'll find my dbcopy utility which can copy data from one
server to another very quickly and my ul.ec utility which will export a
table's contents (actually the result of any SQL SELECT) to a binary
file which is platform independent and reload the file onto another
server. But what I think Bob is thinking of is my dbexport/dbimport
replacement utility myexport which, while it requires my myschema
utility from utils2_ak, is actually a separate package. Myexport also
requires Jonathan Leffler's sqlcmd package and/or Ravi Krishna's
myonpload either of which can optionally be used to actually perform the
exports and imports. Myexport is fully compatible with dbexport and
dbimport but unlike dbexport myexport does not take a lock on the
database, so it can be used successfully in a cron script. Instead it
depends on exporting all tables in parallel to minimize relational
integrity constraint violations during import.

> I'm sure this question has probably been asked before. Is it possible to
> routinely copy data / migrate data from Informix databases between different
> platforms without HDR/ER replication? I've used dbimport/export, and that
> isn't feasible to automate as a cron. I have been reviewing the high
> performance loader utility. It appears to be kind of similar to
> onunload/onload. The reason for the question is that I use Cognos Reporting
> software that is bogging down my production box, Informix 10.00.FC5 under
> HPUX 11.23. It would be nice to do something similar to onunlaod/onload to
> an inexpensive Linux server running IDS 10.00. ER won't work because my ERP
> vendor won't allow primary keys on several tables.
>
> If high performance loader won't "unload" between IDS platforms, will
>

Yes, you can use HPLoader to port data from one platform to another.
The output format for the export files is configurable and a pipe
delimited file such as is used by dbexport/dbimport as well as dbaccess
and dbload is a default option. Myexport uses that feature to emulate
dbexport. Beyond that you can always write your own input and outpuu
translation modules for HPLoader and use whatever format you want.

> archecker/onbar be able to restore from IDS on HPUX to IDS on Linux on
> database or table level?
>

Yes, you can also use archecker's restore feature to read the HPUX tape
and write data to tables on the Linux server. You'll probably have to
run archecker on the HP platform, but as long as that machine's sqlhosts
file knows about the Linux server instance it will be able to write the
rows to tables there.

> Thank-you in advance for any insight or experiences with these tools.
>

No sweat.

Art S. Kagel

> Jonathan B. Smaby
> Pomona College, ITS-AISO Office
> jonathan.smaby@pomona.edu
> Tel. (909) 621-8506
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Messages In This Thread

• Migrating data between Informix Platforms without
  Jonathan Smaby -- Tuesday, 27 November 2007, at 12:23 p.m.
  • Re: Migrating data between Informix Platforms with
    RALPH GENTRY -- Tuesday, 27 November 2007, at 12:43 p.m.
  • RE: Migrating data between Informix Platforms with
    Robert Roussey(IT) -- Tuesday, 27 November 2007, at 12:48 p.m.
  • Re: Migrating data between Informix Platforms with
    Art S. Kagel (Oninit LLC) -- Tuesday, 27 November 2007, at 1:42 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.