Re: Migration of Data

Bob Baskett wrote: >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... Bob, you are right! What I should have said is: Both the old and the new database [servers] need the same logging level: either both no logging or both logging Catalin. -- _____ _____ _____ _____ _ _ _____ Catalin Badea _____/ _____/ _____/ _____/ _/_ _/ _____/ Senior Technical Architect _/ _/___ _/ _/____ _/_/ _/____ Tecsys Inc. _/ ____/ _/ _____/ _/ _____/ _/ _/____ _/___ ____/ _/ ____/ cat@tecsys.com _/ _____/ _____/ _____/ _/ _____/ include system "disclaim.4gh"