RE: Copy a database
Posted in 2000
Hi,
I'm intent to replicate my database from one instance to another one. Could
you please send me a copy of your utility?
TIA,
Jason
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.