Re: Migration of Data

Catalin Badea (cat@tecsys.com) wrote: : dproksch@vrx.vhi.com wrote: : : We are in the processing of moving from a Pyramid ES to a Pyramid NILE : : computer, as well as going from 5.x to 7.10. Inorder to pull this : : off, I need to unload/load all the data. Does anyone have any : : suggestions (other than praying a lot) on how to pull this off : : in a relatively timely manner? Previous migrations at this company : : have involved unloading to a named pipe, some smoke and mirrors : : I don't quite understand, then reading from another named pipe : : and then feeding load or dbload. Is there a way write to a socket : : and read from the socket and then feed load/dbload? I am going to : : move ~50GB of data. : Why don't you keep it simple by using the power of Informix Star : (now included in 6.0 and 7.1): : 1. Recreate your database on your new server (dbschema). : 2. Define entries in the sqlhosts, services, etc... for both : servers (old/new) : 3. dbaccess and connect to your old server. : 4. For each table use: : insert into your-db@newserver:tablename : select * from tablename : Note: step 4 can be an easily generated script. : Caveats: : Databases must have logging. : Tested between 6.x and 7.x. (Have not tried it with 5.x, though : it shouldn't be any different) : : Catalin Dave, I like unloading directly to tape drives. Since you have large tables, you will need to unload only as much as will fit on a tape, for example tape1 might contain customers a-f, tape2 will contain g-m, etc. It is simple and reliable, giving you a backup as well. unload to /dev/rmt/9 select * from tab1 where customer between "a" and "f"; then load from /dev/rmt/9 insert into newtab1; -- ================================================================ Michael T. Reed, DBA, HCIA, Inc. | email: mreed@hcia.com 24 Frank Lloyd Wright Dr. PO Box 303 | voice: 313-930-7943 Ann Arbor, MI 48106-0303 | fax : 313-769-6544