Author Topic: Import database Informix schema from ODBC... (Read 5698 times)

incanus · « **on:** January 19, 2007, 11:20:08 am »

i need to know if its posible to importa DB schema from ODBC, of a Informix DB.
i wonder if i should create a database datatype for informix first...
Have someone performed this operation with a Informix DB?

«Midnight» · « **Reply #1 on:** January 19, 2007, 11:52:56 am »

No, I've not done this with Informix. I have done a few beyond what Sparx provides though.

My suggestion is that you should create a datatype set before you do the serious download.

But first, just to make sure you aren't wasting your time, try a dry run. Make sure you have an ODBC or OLEDB driver for Informix, and that you can create a data source on your working machine. You can perform the actual data source creation either before or during the import.

Try connecting to an Informix database via EA's dialogs, and then try an import. The data types won't be perfect, but you'll quickly find out whether EA will do this at all. If it will, examining how EA maps data types may help you in your definitions.

Please let us know how it works.

David

incanus · « **Reply #2 on:** January 22, 2007, 06:43:02 am »

Yes i have done this earlier, but it imports every field as a varchar datatype.
I mean that ea imports all the db schema fine, but with the wrong field datatype.
regards.

«Midnight» · « **Reply #3 on:** January 22, 2007, 06:53:10 am »

Does it do this after you've created your custom database and data types?

If so, try setting the default database to your custom product - you should be able to do this using the same dialog you used to set up the database.

See if this jogs EA into correctly identifying your database and field types.

incanus · « **Reply #4 on:** January 22, 2007, 11:07:22 am »

No, this behavior was before i create de database and its datatypes.
Now with the database and the datatypes created, it imports all ok.
Thanks.

incanus · « **Reply #5 on:** January 24, 2007, 12:06:13 pm »

Actually it still import with varchar type, i will try settings informix as the default product...

incanus · « **Reply #6 on:** January 25, 2007, 07:15:00 am »

i have created te product (informix) and set up as the default product, then created the datatypes, but it still imports every field as a varchar, any ideas of what can i do, or EA just can't do this...
best regards

Aaron B · « **Reply #7 on:** January 25, 2007, 03:31:08 pm »

From memory, I'm pretty sure that any database type not directly supported by EA will import all datatypes as Varchar (as it does not have the appropriate mappings).

So basically EA can import table structures from some unsupported database types, but it will not be able to correctly capture the datatypes.

incanus · « **Reply #8 on:** January 26, 2007, 04:48:44 am »

Then i must ask if there is a chance of adding Informix as a supported database...
Best regards.

«Midnight» · « **Reply #9 on:** January 26, 2007, 11:13:13 am »

And Ingres - which has been open source and no cost for some time now - for that matter.

Paolo F Cantoni · « **Reply #10 on:** January 26, 2007, 03:10:34 pm »

And Firebird (although there is limited support via InterBase)

Paolo

Sparx Systems Forum

News: