As of Ingres 2.6, copydb -help shows you can copy out rules and
procedures with extra parameters to copydb such as -with_proc
-with_rules. I would think this is what you need to get your procedures
and rules copied out.
$ copydb -help
E_UG0011 Correct syntax:
copydb [-param_file=filename] | [ dbname [-c] [-row_labels]
[-uusername]
[-Ggroupid ] [-parallel] [-journal] [-P] [-source=dirname]
[-dest=dirname] [-ddirname] [-with_tables] [-with_modify]
[-with_data]
[-all] [-order_ccm] [-with_index] [-with_constr] [-with_views]
[-with_synonyms] [-with_events] [-with_proc] [-with_reg]
[-with_rules]
[-with_alarms] [-with_comments] [-with_roles] [-add_drop]
[-infile=filename] [-outfile=filename] [-with_permits] [-relpath]
[-no_loc] [-no_perm] [-noint] [-no_persist] [-no_repmod]
{tablename|viewname}]
- Denise
Denise Vancil
Senior Quality Assurance Engineer
Ingres Cor****ation
denise.vancil@[EMAIL PROTECTED]
This transmission is confidential and intended solely for the use of the
recipient named above. It may contain confidential, proprietary, or
legally privileged information. If you are not the intended recipient,
you are hereby notified that any unauthorized review, use, disclosure or
distribution is strictly prohibited. If you have received this
transmission in error, please contact the sender by reply e-mail and
delete the original transmission and all copies from your system.
-----Original Message-----
From: info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of
Norhaza Yusoff
Sent: Thursday, May 08, 2008 11:19 AM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] copydb with rules/procedures?
Hello everyone,
Is there a way to copy a table and get all the related rules and
procedures be included in the copy.in script?
We have been having a problem of forgetting to include the rules and
procedures into the new table whenever we do the copydb to a table,
which results in missing rules and procedures for that table.
Anyone who has experienced with this issue or who knows the answer,
please give us some insights.
Thanks.
_______________________________________________
Info-Ingres mailing list
Info-Ingres@[EMAIL PROTECTED]
|
