Microsoft Access to MySQL migration problem
Posted by: Paul Hampson
Date: May 10, 2005 06:03AM

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.

Options: ReplyQuote


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.