=== Generated by: Interbase DataPump v 3.4 === Start Pumping: 11/1/2002 5:24:19 PM === Source Database: E:\IBDataPump\Data\UPD_OLD.GDB SQLDialect: 1 user_name=SYSDBA password=gems2000 TURBO WI-V5.6.0.29 === Destination Database: E:\IBDataPump\Data\UPD_NEW.GDB SQLDialect: 1 user_name=SYSDBA password=gems2000 TURBO WI-V5.6.0.29 === Alter triggers > Data Committed. === Empty Tables DELETE FROM EMPLOYEE > Data Committed. DELETE FROM DEPARTMENT > Data Committed. === Destination Execute SQL: CREATE_MY_GEN Custom SQL: CREATE GENERATOR MY_GEN > Data Committed. === Table: INS_DEPARTMENT -- Source Custom SQL: select DEPARTMENT_NAME from EMPLOYEE group by DEPARTMENT_NAME -- Dest Custom SQL: INSERT INTO DEPARTMENT (ID, NAME) VALUES (GEN_ID(MY_GEN, 1), :NAME) > Data Committed. --- Source Records Processed: 3 === Table: INS_EMPLOYEE -- Source SQL: SELECT * FROM EMPLOYEE -- Dest Custom SQL: INSERT INTO EMPLOYEE (ID, DEPARTMENT_ID, NAME, SURNAME) VALUES (:ID, (SELECT ID FROM DEPARTMENT WHERE NAME=:DEPARTMENT_NAME), :NAME, :SURNAME) > Data Committed. --- Source Records Processed: 6 === Destination Execute SQL: DROP_MY_GEN Custom SQL: delete from RDB$GENERATORS where RDB$GENERATOR_NAME = 'MY_GEN' > Data Committed. === Alter triggers > Data Committed. === Update Generators > Data Committed. === All Fine! === Statistical Info === EMPLOYEE: Destination Records Deleted - 6 DEPARTMENT: Destination Records Deleted - 3 CREATE_MY_GEN: INS_DEPARTMENT: Source Records Processed - 3 Destination Records Affected - 3 INS_EMPLOYEE: Source Records Processed - 6 Destination Records Affected - 6 DROP_MY_GEN: Destination Records Affected - 1 === Total Source Records Processed: 9 === Finish Pumping:11/1/2002 5:24:20 PM