[[Lepe]]

Y vamos a la página 67 para una correcta migración de los datos:

Empezado por datadef.pdf

1. Back up your original database. Read the “migration” chapter in Getting
Started to determine what preparations you need to make before migrating
the database. Typically, this includes detecting metadata that uses double
quotes around strings. After making necessary preparations, back up the
database using its current GBAK version and restore it using InterBase 6.
2. Use gfix -set_db_SQL_dialect 3 to change the database to dialect 3
3. Use the ALTER COLUMN clause of the ALTER DATABASE statement to change the
name of each affected column to something different from its original name.
If column position is going to be an issue with any of your clients, use ALTER
COLUMN to change the positions as well.
4. Create a new column for each one that you are migrating. Use the original
column names and if necessary, positions. Declare each one as a DECIMAL or
NUMERIC with precision greater than 9.
5. Use UPDATE to copy the data from each old column to its corresponding new
column:
UPDATE tablename
SET new_col_name = old_col_name;
6. Check that your data has been successfully copied to the new columns and
drop the old columns.
Note If you are migrating exact numeric columns to a dialect 1 database in InterBase 6,
no special steps are needed. A dialect 1 database in InterBase 6 behaves just like an
InterBase 5 database. Dialect 1 is an old standard, however, and will eventually not be
supported by InterBase.

Saludos