RE: Copy a database

Why dont you lock source tables in share mode instead of isolation=dirty read?. While loading, disable triggers and constraints. > -----Mensaje original----- > De: Art S. Kagel [SMTP:kagel@bloomberg.net] > Enviado el: Mi'rcoles 8 de Noviembre de 2000 02:45 PM > Para: informix-list@iiug.org > Asunto: Re: Copy a database > > Nebojsa Sevo wrote: > > > > How does you and others (Art's MYEXPORT for example) utility handle > referential > > constraints? > > If isolation is dirty read than you utility will read "detail" rows > without > > "master" one. > > True you MAY have to reorder the tables in the schema file to hash this > one > out. I have it on my list to enhance myschema to make the requisite > analysis to output the tables in optimal order for a successful load. > > Art S. Kagel > > > Nebojsa > > > > On Fri, 03 Nov 2000 20:09:35 GMT, Norman Erickson Lugtu > <elugtu@my-deja.com> > > wrote: > > > > >I created a utility that will export the database in the none exclusive > > >mode. The trick here is to read the systables database to select all > > >tables from your database to create an unload command of each table and > > >set the isolation to dirty read before unloading this. > > > > > > > > >If you want this utility, please e-mail me. > > > > > >In article <8tun52$7uc$1@reader1.imaginet.fr>, > > > "Gilles Lenfant" <glenfant@equod.com.nospam> wrote: > > >> Hi from the newbie, > > >> > > >> I found lots of options and commands in the giant documentation > > >coming with > > >> IIF. I did not find anything to make a copy of a database. > > >> I can do this through "dbexport" / "dbimport" but this is heavy and > > >requires > > >> to go to "single user" mode for the whole server this includes - THIS > > >I > > >> DON'T WANT. > > >> Is there a way to make a deep copy (structures + data + procedures > > >+ ...) of > > >> a running database to another one ? > > >> > > >> TIA > > >> > > >> Gilles Lenfant > > >> > > >> > > > > > > > > >Sent via Deja.com http://www.deja.com/ > > >Before you buy.