Re: Migration question

David E. Grove wrote: >>You can use multiple copies of my dbcopy utility to copy the data >>directly from the old server to the new one once the DB is setup. The >>utils4_ak package has awk scripts that post-process dbschema/myschema > > output > >>to produce a dbcopy script (among others). >> > > > Thank you, Art. I will check out dbcopy. I'm inferring from your > suggestion that dbcopy would facilitate getting a consistent copy of an > online database from one server to another. That sure would be what the > doctor ordered. Check out Paul's comments on consistency. Dbcopy has no way to guarantee internal consistency between tables so as Paul and Dirk point out plan on using downtime for the copy. Also, vis Paul's methodology, note that my dbschema replacement, myschema, will optionally separate the CREATE TABLE DDL from the indexes and constraints into separate files (and optionally an additional file containing UPDATE STATISTICS statements needed to replicate the source server's levels of stats). That can be helpful. Art S. Kagel