Table missing from Access migration

[Stephen McBurnie]

Using the 1.0.6 beta version of the migration toolkit, all but 1 of 54 tables from one database and 1 of 17 in another failed to migrate. In the first case the "create" script appears below, as does the script for a near identical table which did migrate.

In both instances, no mapping errors were reported nor were any "hidden" errors as occurred in version 1.0.5. Both tables reported as created and data transferred. The first had about 400 rows, the 2nd was empty.

FAILED TABLE Script:

CREATE TABLE `Migrate_Testl`.`Call_Codes_Default_Plan` (
`Call_Destinations` VARCHAR(50) NULL,
`Call_Codes` INTEGER(10) NULL,
`Call_Type` VARCHAR(1) NULL,
`Off_Peak` TINYINT(1) NOT NULL,
`Flag_Fall` DECIMAL(19, 4) NULL,
`Retail_Min` DECIMAL(19, 4) NULL,
`Wholesale` DECIMAL(19, 4) NULL,
`BC_Time` DOUBLE(15, 5) NULL,
`BC_Flag` DOUBLE(15, 5) NULL,
PRIMARY KEY (`Call_Destinations`, `Call_Codes`),
INDEX `TYPE` (`Call_Type`),
INDEX `TYPE` (`Call_Destinations`)
)
ENGINE = INNODB;

Successful Table Script:

CREATE TABLE `Tbill_Data`.`Tariffs` (
`Tariff_Plan` VARCHAR(50) NULL,
`Call_Code` INTEGER(10) NULL,
`Off_Peak` TINYINT(1) NOT NULL,
`Flag_Fall` DECIMAL(19, 4) NULL,
`Rate_Min` DECIMAL(19, 4) NULL,
`Rate_Sec` DECIMAL(19, 4) NULL,
`BC_Time` DOUBLE(15, 5) NULL,
`BC_Flag` DOUBLE(15, 5) NULL,
PRIMARY KEY (`Tariff_Plan`, `Call_Code`, `Off_Peak`),
INDEX `Call_Code` (`Call_Code`)
)
ENGINE = INNODB;

Here is the other "Create" script which failed to transfer.

CREATE TABLE `Migrate_Testl`.`Billing_File` (
`CallID` INTEGER(10) NULL AUTO_INCREMENT,
`CustomerID` INTEGER(10) NULL,
`Customer_Number` VARCHAR(6) NULL,
`Cost_Centre` VARCHAR(8) NULL,
`CLI` VARCHAR(12) NULL,
`Call_Type` VARCHAR(1) NULL,
`Call_Type_Desc` VARCHAR(50) NULL,
`Call_Date` DATETIME NULL,
`Call_Time` DATETIME NULL,
`Number_Dialled` VARCHAR(30) NULL,
`Location` VARCHAR(255) NULL,
`Duration` INTEGER(10) NULL,
`Hours` INTEGER(10) NULL,
`mins` VARCHAR(2) NULL,
`Secs` VARCHAR(2) NULL,
`Call_Duration` VARCHAR(10) NULL,
`Call_Charge` DECIMAL(19, 4) NULL,
`Call_Price` DECIMAL(19, 4) NULL,
`Bcard_Credit` DECIMAL(19, 4) NULL,
`Billed` INTEGER(10) NULL,
PRIMARY KEY (`CallID`),
INDEX `Number_Dialled` (`Number_Dialled`),
INDEX `Sortit` (`CustomerID`),
INDEX `Sortit` (`Cost_Centre`),
INDEX `Sortit` (`CLI`),
INDEX `Sortit` (`Call_Date`),
INDEX `Sortit` (`Call_Time`)
)
ENGINE = INNODB;


Any advice appreciated

Stephen



Edited 2 time(s). Last edit at 05/23/2005 12:57AM by Stephen McBurnie.