Book a Demo

Author Topic: Problem Importing MySQL Schema  (Read 2123 times)

dev@carmeq

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I hate ops without good props.
    • View Profile
Problem Importing MySQL Schema
« on: January 11, 2007, 02:52:04 am »
Hello,

I use the EA 6.5.797 Professional Edition and the problem is that the relations between tables aren't imported. I try to import an InnoDB database with foreign keys with the help of the ODBC driver.
In the output there is the error statement "unexpected symbol: ON" for each table. The unparsed code is written in the comments like this:

COMMENT='InnoDB free: 11264 kB; (`FK_user`) REFER `php_webint/rel_user`(`user`) ON UPDATE'

The DDL generation syntax differs from that (e.g. REFERENCES instead of REFER).

The MySQL version is 5.0.22 community release.
How can I solve this problem?

Greetings from Germany!

dev@carmeq

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I hate ops without good props.
    • View Profile
Re: Problem Importing MySQL Schema
« Reply #1 on: January 15, 2007, 03:43:14 pm »
Thanks a lot for all the answers!  :-[

I saw that there are bug fixes for this problem in release 800 and 801. Do they run without this problem?
In my company all software matters last too long. So I would wait for an update 2 weeks at least.
« Last Edit: January 15, 2007, 03:43:40 pm by dev@carmeq »

thomaskilian

  • Guest
Re: Problem Importing MySQL Schema
« Reply #2 on: January 15, 2007, 10:56:44 pm »
Here is another 'answer': The problem you describe looks like some kind of bug (not sure, though). If you can reproduce the behaviour then you should report it to Sparx. Be sure to have everything at hand for reproduction (especially the DDL to create the RE'ed table).