Re: [Info-Ingres] How to copy a db data -
11-19-2009
, 08:56 AM
Suggest using unloaddb if an exact copy of the database is required
(ie all user objects & system catalogs)
On the source machine:
c:
md work
cd work
unloaddb mydb
unload.ing > out.log
find "E_" out.log
On the target machine:
c:
md work
cd work
copy \\sourcemachine\c$\work\*.*
createdb mydb
reload.ing > in.log
find "E_" in.log
Regards,
Dave.
__________________________________________________ ____________
This message has been checked for all viruses by BTnet VirusScreen.
The service is delivered in partnership with MessageLabs and does not scan any password protected or encrypted attachments.
Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the company. The contents of this email are confidential to the addressee and may also be privileged. If you are not the addressee of this email, you must not copy, forward, disclose or otherwise use it, or any part of it, for any purpose, nor disclose its contents to any other person. If you have received this email in error please notify the sender. Please be aware that any email sent to, or received from, this address may be monitored for quality control, staff training or security purposes. Although the company scans all outgoing email and attachments for viruses, neither the sender nor the company accepts any responsibility for viruses and it remains the responsibility of the recipient to scan email and attachments (if any) for viruses. |