Microsoft Access to MySQL migration problem
I am trying to migrate an Access 2000 database to MySQL 5.0.4 and as you can see from the summary provided by the My SQL Migration toolkit (below) it seems to work. However, I cannot find the tables or even the Schema and the MySQL administrator says that it doesn't even exist. What's going wrong?
Thanks
Paul
Summary from MySQL Migration toolkit :
--------------------------------------------------------------------------------
-- MySQL Migration Toolkit Report --
-- --
-- Title: Summary Of The Migration Process --
-- Date: 2005-05-10 14:46 --
--------------------------------------------------------------------------------
1. Schema Migration
-------------------
Number of migrated schemata: 1
Schema Name: MACAD2_Master
Tables: 40
Views: 0
Procedures: 0
Triggers: 0
Structured Types: 0
Details:
Tables
`MACAD2_Master`.`AggregateSchedules`
`MACAD2_Master`.`AircraftModels`
`MACAD2_Master`.`AircraftStatistics`
`MACAD2_Master`.`AircraftTypeAttributes`
`MACAD2_Master`.`AircraftTypeFractions`
`MACAD2_Master`.`AircraftTypes`
`MACAD2_Master`.`AirlineFractions`
`MACAD2_Master`.`AirlineHandlers`
`MACAD2_Master`.`Airlines`
`MACAD2_Master`.`Airports`
`MACAD2_Master`.`ApronAircraftTypes`
`MACAD2_Master`.`ApronAttributes`
`MACAD2_Master`.`ApronHandlers`
`MACAD2_Master`.`ApronStands`
`MACAD2_Master`.`FlightScheduleFlights`
`MACAD2_Master`.`FlightSchedules`
`MACAD2_Master`.`Handlers`
`MACAD2_Master`.`HandlerStatistics`
`MACAD2_Master`.`HourlyConfigurations`
`MACAD2_Master`.`InterArrivalSeparationAttributes`
`MACAD2_Master`.`InterArrivalSeparations`
`MACAD2_Master`.`InterDepartureSeparationAttributes`
`MACAD2_Master`.`InterDepartureSeparations`
`MACAD2_Master`.`OperationTypes`
`MACAD2_Master`.`RunwayConfigurations`
`MACAD2_Master`.`RunwayConfigurationSets`
`MACAD2_Master`.`RunwaySetApproachSpeeds`
`MACAD2_Master`.`RunwaySetEnvelopes`
`MACAD2_Master`.`RunwaySetOccupancyTimes`
`MACAD2_Master`.`RunwaySetOperations`
`MACAD2_Master`.`RunwaySets`
`MACAD2_Master`.`RunwaySetSeparationAttributes`
`MACAD2_Master`.`RunwaySetSeparations`
`MACAD2_Master`.`RunwaySetTypes`
`MACAD2_Master`.`Scenaria`
`MACAD2_Master`.`ScenarioDelayDistributions`
`MACAD2_Master`.`ScenarioFlightDelays`
`MACAD2_Master`.`ScenarioHourlyStatistics`
`MACAD2_Master`.`ScenarioStatistics`
`MACAD2_Master`.`TimeIntervals`
Views
Procedures
Triggers
Structured Types
2. Data Bulk Transfer
---------------------
Completed.
--------------------------------------------------------------------------------
Edited 1 time(s). Last edit at 06/08/2005 10:10AM by Edwin DeSouza.
Subject
Written By
Posted
Microsoft Access to MySQL migration problem
May 10, 2005 06:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.