Re: Transfering tables

Posted in 1997

Michal Hajek — Thu, 18 Dec 1997 12:06:12 +0100 — source: Informix-list mailing list archive (1991-1998)

M Auger wrote: > > We need to transfer some tables between 2 databases on a regular basis. Most > tables have referential constraints, there are hundred of tables we have to > look for. Is there an easy way to list the tables in order they should be > inserted first? I would create the second tables without constraints, load data and create constraints. In case it is done only once (or is it not ?) it seems to me quicker then anything else. Loading data into tables without constraint/indexes is also quicker - there are no integrity controls during load. Michal Hajek -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------