Hi Puneet,

The copydb facility is what you need.

For example to copy a few tables from one database....

copydb -u<table_owner> database_name table_name1 table_name2...

Note that copydb is a fairly option rich utility and you should examine
the other options available in the command. But the above is probably
good enough in most cases. Ypu may like to look at providing the '-c'
option which ensures the data is unloaded in ASCII format.

This command will not actually do the data transfer, it will produce two
scripts that can be used to do the transfer. These are called copy.out
and copy.in.

The data can be copied to disk with:
sql source_database < copy.out

You can then edit the copy.in to alter the target table names to what you
want and then execute the copy.in with:
sql target_database < copy.in

Martin Bowes
>
> Hi,
>
> In Ingress how data is migrated to another version of the database?I
> want to migrate few tables from one version of Ingress to another ,
> both the source and destination table has got same structure. 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 .
>
> Do we have such facility in Ingres also, if not then how migration can
> be done?
>
> Thanks,
> Puneet