Re: Migration of Data

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 -- _____ _____ _____ _____ _ _ _____ Catalin Badea _____/ _____/ _____/ _____/ _/_ _/ _____/ Senior Technical Architect _/ _/___ _/ _/____ _/_/ _/____ Tecsys Inc. _/ ____/ _/ _____/ _/ _____/ _/ _/____ _/___ ____/ _/ ____/ cat@tecsys.com _/ _____/ _____/ _____/ _/ _____/ include system "disclaim.4gh"