Re: Move dbs between various operatiing systems.

----- Original Message ----- From: Kam Bernard <bernard_kam2002@yahoo.com> 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. > 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 rin 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. > 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? 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

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