Re: Access to MySQL migration problem
Posted by: Clive Johnson
Date: June 02, 2005 04:03AM

Hi All,

I think I have the solution: Do you have any indexes called 'Primary'?

If so rename them and it should all work wonderfully..

If you elect to save the table creation SQL and then run it later in the Query Browser you'll see it chokes on the Primary index create call.

I'm seeing this in the SQL generated by the tool:-
...UNIQUE INDEX `Primary` (`ID`),..
rather than
...PRIMARY KEY (`ID`),...

Of course there's nothing to stop you editing the SQL and running it in the Query Browser..

Regards, CliveJ

Edited 1 time(s). Last edit at 06/02/2005 04:17AM by Clive Johnson.

Options: ReplyQuote

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.