=== Generated by: Interbase DataPump v 3.4 === Start Pumping: 11/1/2002 5:35:15 PM === Source Database: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=GAFFEY-DB1 ConnectionString: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=GAFFEY-DB1;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=TURBO;Use Encryption for Data=False;Tag with column collation when possible=False Provider: SQLOLEDB.1 Version: 2.7 Select Option - select * from [A Table] Option "Quote Field Names" is ON === Destination Database: E:\IBDataPump\Data\NORTHWIND.GDB SQLDialect: 1 user_name=SYSDBA password=gems2000 TURBO WI-V5.6.0.29 === Switch Off all Ref. Constraints with loop === Alter triggers ALTER TRIGGER TRIG_ALPHALISTPRODUCTS_BI INACTIVE ALTER TRIGGER TRIG_CATEGORIES_BI INACTIVE ALTER TRIGGER TRIG_CURRRODLIST_BI INACTIVE ALTER TRIGGER TRIG_EMPLOYEES_BI INACTIVE ALTER TRIGGER TRIG_INVOICES_BI INACTIVE ALTER TRIGGER TRIG_ORDERS_BI INACTIVE ALTER TRIGGER TRIG_ORDERSQRY_BI INACTIVE ALTER TRIGGER TRIG_PRODUCTS_BI INACTIVE ALTER TRIGGER TRIG_SALESTOTALSBYAMOUNT_BI INACTIVE ALTER TRIGGER TRIG_SHIPPERS_BI INACTIVE ALTER TRIGGER TRIG_SUMMSALESQUAR_BI INACTIVE ALTER TRIGGER TRIG_SUMMSALESYEAR_BI INACTIVE ALTER TRIGGER TRIG_SUPPLIERS_BI INACTIVE > Data Committed. === Empty Tables DELETE FROM QUARTERLYORDERS > Data Committed. DELETE FROM TERRITORIES > Data Committed. DELETE FROM SUPPLIERS > Data Committed. DELETE FROM SUMMSALESYEAR > Data Committed. DELETE FROM SUMMSALESQUAR > Data Committed. DELETE FROM SHIPPERS > Data Committed. DELETE FROM SALESTOTALSBYAMOUNT > Data Committed. DELETE FROM SALESBYCATEGORY > Data Committed. DELETE FROM REGION > Data Committed. DELETE FROM PRODUCTSBYCATEGORY > Data Committed. DELETE FROM PRODUCTSALESFOR1997 > Data Committed. DELETE FROM PRODUCTSABOVEAVERAGEPRICE > Data Committed. DELETE FROM PRODUCTS > Data Committed. DELETE FROM ORDERSUBTOTALS > Data Committed. DELETE FROM ORDERSQRY > Data Committed. DELETE FROM ORDERS > Data Committed. DELETE FROM ORDERDETAILSEXTENDED > Data Committed. DELETE FROM ORDERDETAILS > Data Committed. DELETE FROM INVOICES > Data Committed. DELETE FROM EMPLOYEETERRITORIES > Data Committed. DELETE FROM EMPLOYEES > Data Committed. DELETE FROM CUSTOMERS > Data Committed. DELETE FROM CUSTOMERDEMOGRAPHICS > Data Committed. DELETE FROM CUSTOMERCUSTOMERDEMO > Data Committed. DELETE FROM CUSTOMERANDSUPPLIERSBYCITY > Data Committed. DELETE FROM CURRRODLIST > Data Committed. DELETE FROM CATEGORYSALESFOR1997 > Data Committed. DELETE FROM CATEGORIES > Data Committed. DELETE FROM ALPHALISTPRODUCTS > Data Committed. === Table: ALPHALISTPRODUCTS -- Source SQL: SELECT * FROM [Alphabetical list of products] -- Dest SQL: INSERT INTO ALPHALISTPRODUCTS (PRODUCTID,PRODUCTNAME,SUPPLIERID,CATEGORYID,QUANTITYPERUNIT,UNITPRICE,UNITSINSTOCK,UNITSONORDER,REORDERLEVEL,DISCONTINUED,CATEGORYNAME) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10) > Data Committed. --- Source Records Processed: 69 === Table: CATEGORIES -- Source SQL: SELECT * FROM [Categories] -- Dest SQL: INSERT INTO CATEGORIES (CATEGORYID,CATEGORYNAME,DESCRIPTION,PICTURE) VALUES (:PAR0,:PAR1,:PAR2,:PAR3) > Data Committed. --- Source Records Processed: 8 === Table: CATEGORYSALESFOR1997 -- Source SQL: SELECT * FROM [Category Sales for 1997] -- Dest SQL: INSERT INTO CATEGORYSALESFOR1997 (CATEGORYNAME,CATEGORYSALES) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 8 === Table: CURRRODLIST -- Source SQL: SELECT * FROM [Current Product List] -- Dest SQL: INSERT INTO CURRRODLIST (PRODUCTID,PRODUCTNAME) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 69 === Table: CUSTOMERANDSUPPLIERSBYCITY -- Source SQL: SELECT * FROM [Customer and Suppliers by City] -- Dest SQL: INSERT INTO CUSTOMERANDSUPPLIERSBYCITY (CITY,COMPANYNAME,CONTACTNAME,RELATIONSHIP) VALUES (:PAR0,:PAR1,:PAR2,:PAR3) > Data Committed. --- Source Records Processed: 120 === Table: CUSTOMERCUSTOMERDEMO -- Source SQL: SELECT * FROM [CustomerCustomerDemo] -- Dest SQL: INSERT INTO CUSTOMERCUSTOMERDEMO (CUSTOMERID,CUSTOMERTYPEID) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 0 === Table: CUSTOMERDEMOGRAPHICS -- Source SQL: SELECT * FROM [CustomerDemographics] -- Dest SQL: INSERT INTO CUSTOMERDEMOGRAPHICS (CUSTOMERTYPEID,CUSTOMERDESC) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 0 === Table: CUSTOMERS -- Source SQL: SELECT * FROM [Customers] -- Dest SQL: INSERT INTO CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10) > Data Committed. --- Source Records Processed: 91 === Table: EMPLOYEES -- Source SQL: SELECT * FROM [Employees] -- Dest SQL: INSERT INTO EMPLOYEES (EMPLOYEEID,LASTNAME,FIRSTNAME,TITLE,TITLEOFCOURTESY,BIRTHDATE,HIREDATE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,HOMEPHONE,EXTENSION,PHOTO,NOTES,REPORTSTO,PHOTOPATH) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10,:PAR11,:PAR12,:PAR13,:PAR14,:PAR15,:PAR16,:PAR17) > Data Committed. --- Source Records Processed: 9 === Table: EMPLOYEETERRITORIES -- Source SQL: SELECT * FROM [EmployeeTerritories] -- Dest SQL: INSERT INTO EMPLOYEETERRITORIES (EMPLOYEEID,TERRITORYID) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 49 === Table: INVOICES -- Source SQL: SELECT * FROM [Invoices] -- Dest SQL: INSERT INTO INVOICES (SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY,CUSTOMERID,CUSTOMERNAME,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,SALESPERSON,ORDERID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPPERNAME,PRODUCTID,PRODUCTNAME,UNITPRICE,QUANTITY,DISCOUNT,EXTENDEDPRICE,FREIGHT) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10,:PAR11,:PAR12,:PAR13,:PAR14,:PAR15,:PAR16,:PAR17,:PAR18,:PAR19,:PAR20,:PAR21,:PAR22,:PAR23,:PAR24,:PAR25) > Data Committed. > Data Committed. > Data Committed. --- Source Records Processed: 2155 === Table: ORDERDETAILS -- Source SQL: SELECT * FROM [Order Details] -- Dest SQL: INSERT INTO ORDERDETAILS (ORDERID,PRODUCTID,UNITPRICE,QUANTITY,DISCOUNT) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4) > Data Committed. > Data Committed. > Data Committed. --- Source Records Processed: 2155 === Table: ORDERDETAILSEXTENDED -- Source SQL: SELECT * FROM [Order Details Extended] -- Dest SQL: INSERT INTO ORDERDETAILSEXTENDED (ORDERID,PRODUCTID,PRODUCTNAME,UNITPRICE,QUANTITY,DISCOUNT,EXTENDEDPRICE) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6) > Data Committed. > Data Committed. > Data Committed. --- Source Records Processed: 2155 === Table: ORDERS -- Source SQL: SELECT * FROM [Orders] -- Dest SQL: INSERT INTO ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10,:PAR11,:PAR12,:PAR13) > Data Committed. --- Source Records Processed: 830 === Table: ORDERSQRY -- Source SQL: SELECT * FROM [Orders Qry] -- Dest SQL: INSERT INTO ORDERSQRY (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY,COMPANYNAME,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10,:PAR11,:PAR12,:PAR13,:PAR14,:PAR15,:PAR16,:PAR17,:PAR18,:PAR19) > Data Committed. --- Source Records Processed: 830 === Table: ORDERSUBTOTALS -- Source SQL: SELECT * FROM [Order Subtotals] -- Dest SQL: INSERT INTO ORDERSUBTOTALS (ORDERID,SUBTOTAL) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 830 === Table: PRODUCTS -- Source SQL: SELECT * FROM [Products] -- Dest SQL: INSERT INTO PRODUCTS (PRODUCTID,PRODUCTNAME,SUPPLIERID,CATEGORYID,QUANTITYPERUNIT,UNITPRICE,UNITSINSTOCK,UNITSONORDER,REORDERLEVEL,DISCONTINUED) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9) > Data Committed. --- Source Records Processed: 77 === Table: PRODUCTSABOVEAVERAGEPRICE -- Source SQL: SELECT * FROM [Products Above Average Price] -- Dest SQL: INSERT INTO PRODUCTSABOVEAVERAGEPRICE (PRODUCTNAME,UNITPRICE) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 25 === Table: PRODUCTSALESFOR1997 -- Source SQL: SELECT * FROM [Product Sales for 1997] -- Dest SQL: INSERT INTO PRODUCTSALESFOR1997 (CATEGORYNAME,PRODUCTNAME,PRODUCTSALES) VALUES (:PAR0,:PAR1,:PAR2) > Data Committed. --- Source Records Processed: 77 === Table: PRODUCTSBYCATEGORY -- Source SQL: SELECT * FROM [Products by Category] -- Dest SQL: INSERT INTO PRODUCTSBYCATEGORY (CATEGORYNAME,PRODUCTNAME,QUANTITYPERUNIT,UNITSINSTOCK,DISCONTINUED) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4) > Data Committed. --- Source Records Processed: 69 === Table: REGION -- Source SQL: SELECT * FROM [Region] -- Dest SQL: INSERT INTO REGION (REGIONID,REGIONDESCRIPTION) VALUES (:PAR0,:PAR1) > Data Committed. --- Source Records Processed: 4 === Table: SALESBYCATEGORY -- Source SQL: SELECT * FROM [Sales by Category] -- Dest SQL: INSERT INTO SALESBYCATEGORY (CATEGORYID,CATEGORYNAME,PRODUCTNAME,PRODUCTSALES) VALUES (:PAR0,:PAR1,:PAR2,:PAR3) > Data Committed. --- Source Records Processed: 77 === Table: SALESTOTALSBYAMOUNT -- Source SQL: SELECT * FROM [Sales Totals by Amount] -- Dest SQL: INSERT INTO SALESTOTALSBYAMOUNT (SALEAMOUNT,ORDERID,COMPANYNAME,SHIPPEDDATE) VALUES (:PAR0,:PAR1,:PAR2,:PAR3) > Data Committed. --- Source Records Processed: 66 === Table: SHIPPERS -- Source SQL: SELECT * FROM [Shippers] -- Dest SQL: INSERT INTO SHIPPERS (SHIPPERID,COMPANYNAME,PHONE) VALUES (:PAR0,:PAR1,:PAR2) > Data Committed. --- Source Records Processed: 3 === Table: SUMMSALESQUAR -- Source SQL: SELECT * FROM [Summary of Sales by Quarter] -- Dest SQL: INSERT INTO SUMMSALESQUAR (SHIPPEDDATE,ORDERID,SUBTOTAL) VALUES (:PAR0,:PAR1,:PAR2) > Data Committed. --- Source Records Processed: 809 === Table: SUMMSALESYEAR -- Source SQL: SELECT * FROM [Summary of Sales by Year] -- Dest SQL: INSERT INTO SUMMSALESYEAR (SHIPPEDDATE,ORDERID,SUBTOTAL) VALUES (:PAR0,:PAR1,:PAR2) > Data Committed. --- Source Records Processed: 809 === Table: SUPPLIERS -- Source SQL: SELECT * FROM [Suppliers] -- Dest SQL: INSERT INTO SUPPLIERS (SUPPLIERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX,HOMEPAGE) VALUES (:PAR0,:PAR1,:PAR2,:PAR3,:PAR4,:PAR5,:PAR6,:PAR7,:PAR8,:PAR9,:PAR10,:PAR11) > Data Committed. --- Source Records Processed: 29 === Table: TERRITORIES -- Source SQL: SELECT * FROM [Territories] -- Dest SQL: INSERT INTO TERRITORIES (TERRITORYID,TERRITORYDESCRIPTION,REGIONID) VALUES (:PAR0,:PAR1,:PAR2) > Data Committed. --- Source Records Processed: 53 === Table: QUARTERLYORDERS -- Source SQL: SELECT * FROM [Quarterly Orders] -- Dest SQL: INSERT INTO QUARTERLYORDERS (CUSTOMERID,COMPANYNAME,CITY,COUNTRY) VALUES (:PAR0,:PAR1,:PAR2,:PAR3) > Data Committed. --- Source Records Processed: 86 === Switch On all Ref. Constraints with loop === Alter triggers ALTER TRIGGER TRIG_ALPHALISTPRODUCTS_BI ACTIVE ALTER TRIGGER TRIG_CATEGORIES_BI ACTIVE ALTER TRIGGER TRIG_CURRRODLIST_BI ACTIVE ALTER TRIGGER TRIG_EMPLOYEES_BI ACTIVE ALTER TRIGGER TRIG_INVOICES_BI ACTIVE ALTER TRIGGER TRIG_ORDERS_BI ACTIVE ALTER TRIGGER TRIG_ORDERSQRY_BI ACTIVE ALTER TRIGGER TRIG_PRODUCTS_BI ACTIVE ALTER TRIGGER TRIG_SALESTOTALSBYAMOUNT_BI ACTIVE ALTER TRIGGER TRIG_SHIPPERS_BI ACTIVE ALTER TRIGGER TRIG_SUMMSALESQUAR_BI ACTIVE ALTER TRIGGER TRIG_SUMMSALESYEAR_BI ACTIVE ALTER TRIGGER TRIG_SUPPLIERS_BI ACTIVE > Data Committed. === Update Generators Custom SQL: SELECT max([Categories].[CategoryID]) as CategoryID FROM [Categories] SET GENERATOR GEN_CATEGORIES_CATEGORYID TO 8 Custom SQL: SELECT max([Employees].[EmployeeID]) AS EmployeeID FROM [Employees] SET GENERATOR GEN_EMPLOYEES_EMPLOYEEID TO 9 SET GENERATOR GEN_ORDERS_ORDERID TO 100 SET GENERATOR GEN_PRODUCTS_PRODUCTID TO 200 > Data Committed. === All Fine! === Statistical Info === QUARTERLYORDERS: Destination Records Deleted - 86 Source Records Processed - 86 Destination Records Affected - 86 TERRITORIES: Destination Records Deleted - 53 Source Records Processed - 53 Destination Records Affected - 53 SUPPLIERS: Destination Records Deleted - 29 Source Records Processed - 29 Destination Records Affected - 29 SUMMSALESYEAR: Destination Records Deleted - 809 Source Records Processed - 809 Destination Records Affected - 809 SUMMSALESQUAR: Destination Records Deleted - 809 Source Records Processed - 809 Destination Records Affected - 809 SHIPPERS: Destination Records Deleted - 3 Source Records Processed - 3 Destination Records Affected - 3 SALESTOTALSBYAMOUNT: Destination Records Deleted - 66 Source Records Processed - 66 Destination Records Affected - 66 SALESBYCATEGORY: Destination Records Deleted - 77 Source Records Processed - 77 Destination Records Affected - 77 REGION: Destination Records Deleted - 4 Source Records Processed - 4 Destination Records Affected - 4 PRODUCTSBYCATEGORY: Destination Records Deleted - 69 Source Records Processed - 69 Destination Records Affected - 69 PRODUCTSALESFOR1997: Destination Records Deleted - 77 Source Records Processed - 77 Destination Records Affected - 77 PRODUCTSABOVEAVERAGEPRICE: Destination Records Deleted - 25 Source Records Processed - 25 Destination Records Affected - 25 PRODUCTS: Destination Records Deleted - 77 Source Records Processed - 77 Destination Records Affected - 77 ORDERSUBTOTALS: Destination Records Deleted - 830 Source Records Processed - 830 Destination Records Affected - 830 ORDERSQRY: Destination Records Deleted - 830 Source Records Processed - 830 Destination Records Affected - 830 ORDERS: Destination Records Deleted - 830 Source Records Processed - 830 Destination Records Affected - 830 ORDERDETAILSEXTENDED: Destination Records Deleted - 2155 Source Records Processed - 2155 Destination Records Affected - 2155 ORDERDETAILS: Destination Records Deleted - 2155 Source Records Processed - 2155 Destination Records Affected - 2155 INVOICES: Destination Records Deleted - 2155 Source Records Processed - 2155 Destination Records Affected - 2155 EMPLOYEETERRITORIES: Destination Records Deleted - 49 Source Records Processed - 49 Destination Records Affected - 49 EMPLOYEES: Destination Records Deleted - 9 Source Records Processed - 9 Destination Records Affected - 9 CUSTOMERS: Destination Records Deleted - 91 Source Records Processed - 91 Destination Records Affected - 91 CUSTOMERDEMOGRAPHICS: Destination Records Deleted - 0 Source Records Processed - 0 Destination Records Affected - 0 CUSTOMERCUSTOMERDEMO: Destination Records Deleted - 0 Source Records Processed - 0 Destination Records Affected - 0 CUSTOMERANDSUPPLIERSBYCITY: Destination Records Deleted - 120 Source Records Processed - 120 Destination Records Affected - 120 CURRRODLIST: Destination Records Deleted - 69 Source Records Processed - 69 Destination Records Affected - 69 CATEGORYSALESFOR1997: Destination Records Deleted - 8 Source Records Processed - 8 Destination Records Affected - 8 CATEGORIES: Destination Records Deleted - 8 Source Records Processed - 8 Destination Records Affected - 8 ALPHALISTPRODUCTS: Destination Records Deleted - 69 Source Records Processed - 69 Destination Records Affected - 69 === Total Source Records Processed: 11562 === Finish Pumping:11/1/2002 5:35:27 PM