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 Corporation

denise.van...@ingres.com
www.ingres.com

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.