[Info-Ingres] DataMigration

[Jean-Pierre Zuate]

2007/3/15, Puneet Bagoria <puneet138 at gmail.com>:
>
> Like for Oracle database Toad provides feature to generated insert scripts
> to a flat text file and these scripts can be used to load the data using
> toad .
>

Hello,

Same answer the others guru's explain to you (copydb), with an add-on : have
a look at copydb parameters.

You can extract only the SQL orders you want : create table, create index,
copy into, copy from, etc. (even add drop table before create if you need).

Take care of values of few variables between 2 Ingres systems :
- II_DATE_FORMAT
- II_DECIMAL
- II_MONEY_FORMAT
- II_MONEY_PREC
...

Extract from Command Reference Guide :
copydb [-param_file=filename] | [dbname|vnode::dbname[/server_class] [-c]
[-row_labels] [-uusername] [-Ggroupid] [-parallel] [-P] [-source=dirname]
[-dest=dirname] [-dirname] [-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] [-with_sequences]
[-add_drop][-infile=filename] [-outfile=filename] [-with_permits]
[-relpath]
[-no_loc] [-no_perm] [-no_int] [-no_persist] [-no_repmod] [-no_seq]
[-nodependency_check] {tablename|viewname} [-online]

HTH
-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070315/02a2b7f5/attachment.html