--- In Firebird-Java@yahoogroups.com, Rocky Castaneda
<rockycastaneda@y...> wrote:

> Sounds like a migration problem to me, if you want an
> easy way to transfer data from legacy tables to
> interbase, you can use Interbase Data Pump from clever
> components i think its free.
>
> HTH,
>
> -rocky

I did actually try that for the migration but didn't get very far with
it. The second stage of the migration (where I'm having trouble with
the initial generator values) is actually a significant data massaging
exercise. Infact the data being massaged is in the same database in a
whole lot of temporary tables (of a different structure) so that SQL
can extract data out of them into the nice new normalised tables.
I found IDP didn't offer me much flexibility in migrating data from
one set of tables in the database to a new set of tables in the same
database. It seemed more suited to getting data from an entirely
different datasource (and type of database) and inserting it into a
firebird database. So I wrote my own drag & drop gui with lots of nice
colours ;-) which works with the database metadata, etc....

Anyway, the problem isn't with that, it's with the initial few records
inserted before (which have the correct structure of the new database)
that upset the generator which isn't 'aware' that records have been
inserted behind its back.

Phil