Book a Demo

Author Topic: importing timestamps from a mysql db  (Read 2268 times)

llennhoff

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
importing timestamps from a mysql db
« on: June 15, 2007, 05:18:13 am »
Hi

I'm evaluating EA for my team, so I only have a trial copy for release 6.5. I tried to import a mysql database into EA and found that when I inspected the model, all columns that in the database were of type TimeStamp did not have a data type indicated. This meant that when I generated the ddl from the model, the existing sql was invalid.

I checked the forums and saw this was a bug in 2006.  Has it been fixed?  Could a more experienced user tell me a way I could quickly add the missing datatype to all the columns? The majority of the column names end in DateTime if that helps.

In general what are people's experiences using Enterprise Architect to generate and import mysql code?  Has the problem with multiple foreign keys been resolved?