Author Topic: Import of SQL DDL with Comments  (Read 3207 times)

zaunere

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Import of SQL DDL with Comments
« on: September 16, 2005, 07:53:02 am »
I'm looking to import over 1000 tables from SQL DDL text files (CREATE TABLE commands).  Each CREATE TABLE statement also includes comments.

I can run the SQL commands through MySQL, then import via a ODBC connection into EA.  However, the tables don't include the comments.

So two questions/requests:

-- import SQL DDL directly from text file?
-- import DDL from MySQL with comments?

Regards,

Hans Zaunere