Re: Migration Challenge 200+ GB to new host platform

>Along with completing the task of moving the data, we intend to use this as >an >opportunity to perform other maintenance tasks. The tables and indexes need >work such as re-fragment, re-calculate extents, and compression of spaces, >which can not be done with a methodology of a simple archive and restore. >The archive and restore method would move the database just as it exists, >and we want to clean it up along the way to the new platform. What about a dbexport? You can make all your changes to the script before you do the re-import. Gives you nice clean indexes and well-extented data, too! >Constraints, which face the team, include such things as minimal downtime, >no impact to the production system, day to day processing can not stop, and >so on. Basically get this done while the current production system continues >to do it's job. Of course. Are you 24x7? >In doing this work without the archive and restore method, we have a plan >which restores the data to a test system to be unloaded table by table and >loaded to the new system. With the constraint that the current production >system keeps working with its data changing every day, the challenge to know >that the old and new systems are in sync at the end is huge. You should also look at the High Performance Loader to help with this. >We have a skilled programmer who has studied the documentation associated >with the logical logs and understands what is captured in them. The >programmer tells me that the operations of insert and update will be not >difficult to pull from the log tapes and decipher the transaction and then >create SQL code to re-apply each transaction on the new system. It seems at >this time that the delete operations are not as clear and easy to decipher. >The programmer tells me that the delete operation appears to basically >offset a number of bytes into the partition to a specific location and then >writes to blank the information and make that page slot available for a new >record. AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA!!!!! Shoot him now, before he does some real damage! :-) He's right, of course, but he really shouldn't be delving around in there. You don't mention what products you're using, but why don't you try using Enterprise Replication in 7.2x or greater? Good luck. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? Get Your Private, Free Email at http://www.hotmail.com