Re: Migration of Data
catalin,
why require logging? here is what we do on a regular basis:
1. update statistics for all databases in the source instance (SI for short)
2. generate the schema from SI (i wrote a customer schema program that has
an option to insert 'INSERT INTO table SELECT * FROM DB@HOST:table' right
after creating the table and just before creating the indexes).
3. run the script generated in step #2 on the target instance (TI for short).
4. update statistics for all databases in TI
5. run select tabname,nrows from systables for all databases in both instances
and compare the output. fix any tables that did not get completely copied.
the above doesnt require transactions and creates the indexes on the tables
after the load has occurred (real time saver). should work for all versions
of online...
}
} 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"
}
}
--
regards,
+----------------------------------------------------------------------------+
| . . | Bob Baskett |
| ... ... | Software Engineer |
| ..... ..... | Business Systems Integration Group |
| .. ... .. | Semiconductor Products Sector |
| . . . | Mesa, AZ |
| | President, Informix Users Group Of Arizona |
| Motorola, Inc. | |
+----------------------------------------------------------------------------+
| Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 |
+----------------------------------------------------------------------------+