IDS Forum

Re: Move dbs between various operatiing systems.

Posted By:
Date:

Hi,
Thanks for your help, please see my comments on your words below.

"ART KAGEL, ...." <KAGEL@bloomberg.net> wrote:

----- Original Message -----
From: Kam Bernard
At: 2/25 7:31

>
> Hi All,
>
> I am planing to port my database that is running well on WinNT to Linux box.

Dbexport/dbimport is the preferred method. HOWEVER, you MAY run into some
problems dbimporting due to index and constraint names that were defaulted on
the source database but were exported by dbexport as hard names and with some
object owner names which may clash with some defaulted names and with the user
running the import on the target server during the dbimport run. If that
happens you either have to edit the schema to remove these constraint names (you
will recognize them, they have a letter and two number separated by underscores
and include ALL the names of NOT NULL CONSTRAINTs) or get my dbschema
replacement utility, myschema, and run it with its -l dbimport compatibility
option and -O to remove object owner names and replace the dbexport schema with
the one myschema produces.

============

Yes, i als ohad some ideas as you mentioned above, but the problem is that althought i can ran dbimport on linux from exported database resulted from running dbexport ultility on WimNT completed but this process seems just create schema for database, it's not loaded data files that created from dbexport ultility, therefore i tried to run SQL command as unload & load to unload and then load data from source database back to new datanase on target server, this work takes spends much time and in some case if the database structure is so complex, to unload & load data completed, i must understand well relationship between tables in order to help me know how is the order tables to load data.







> Would any know this, please teach me some correct methods in order to move
> entire a database on WinNT to Linux platform, in which both platforms are
> installed IDS 2000.
>
> I tried to run dbexport from WinNT, then i ran dbschema and unload ultility on

I don't understand. The inverse utility for a dbexport load is dbimport not
unload! Indeed, Informix does not deliver ANY utility named 'unload'. Are you
trying to run the schema manually then use the LOAD verb in dbaccess to reload
the data manually one table at a time? Why? If so you will run into the same
problems you MIGHT see running dbimport so see my notes above.

=============

yes, you're right, i mis understood unload metioned here, unload/load utility is SQL commands that i can run to unload data from source tables, then load unloaded data files back to the database on target server.





> Linux box that had installed IDS 2000 with the same version on WinNT but
there
> is always have much problems issues during creating tables & unload data from
> load files, this problems seems caused by wrong data format in load files ??.,

Hmm, perhaps a terminology problem? You UNLOAD a database to flat files the
LOAD the data files back into the database. Perhaps you are trying to use the
dbaccess UNLOAD verb when you should be using LOAD?.

=========================

I tried to run unload /load ob both dbaccess(linux box ) and SQl editor on one workstation.



Art S. Kagel

> if this case, pls tell me how to convert load data format files WinNT to
correct
> data format on Linux box.
>
>
>
> Thanks,
>
> Bernard
>
>
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, and more






---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

Messages In This Thread

• Re: Move dbs between various operatiing systems.
  ART KAGEL, BLOOMBERG/ 65E 55TH -- Tuesday, 25 February 2003, at 8:37 a.m.
  • Re: Move dbs between various operatiing systems.
    Kam Bernard -- Wednesday, 26 February 2003, at 1:29 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.