Re: Data Migration Question

Hello Rob, are you shure that your database export size is more than 2G? In this case, you can work as follow: 1. dbschema -d database database.sql 2. "select * from tablename unload to tablename.sql" for each table 3. copy the unl.files via rcp to your new server 4. dbaccess - database.sql 5. "load from tablname.sql insert into table" for each table Please notify, that it is better to add your indexes after loading the refering table. Also, you have to lock each table exclusive to prevent of too many locks. Yours, Volker rlee_rg@my-dejanews.com schrieb: > > Hi, > > We are migrating a 20+ GB database from Online 7.10/HP-UX 9.04 to 7.24/HP-UX > 10.20 between two different servers. > > For the purpose of speed and reliability, we'd like to avoid using tapes if > possible. Because the 2GB file system limitation on HP-UX, we can not use > dbexport/dbimport on disk. What are the other alternatives? > > Also if we have to use tape, is dbexport/dbimport compatible with DLT tapes? > > Due to the time requirement, we are not able to use third party products for > this project. > > Thanks for your answers! > > Rob > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum -- Volker Fraenkle CS Controlling Technical Consultant Software Systeme GmbH E-Mail: VFraenkle@cs-controlling.de Phone: +49 7144 8144-0 Riedbachstrasse 5 Fax: +49 7144 8144-10 D-74385 Pleidelsheim