Reverse engineering a database in to EA

[M Baird]

Hi

I'm using EA 7.5 on Windows 7 and have a large table in SQL Server 2008 that I want to being into a database design in EA.  It has lots of fields so I don't want to re-type everything.

In my database design I right click on  "Code Engineering -> Import DB Schema from ODBC" expecting to be able to navigate to my database and table.  However once I click on "Import DB Schema..." nothing happens!

Any ideas on how I can use this feature?

Thanks

Mark

[Geert Bellekens]

EA is rather specific in which driver you use.
IIRC "OLEDB driver for SQL Server" should work.

Geert

[M Baird]

Hi

Thanks for getting back to me.

I don't even get an option to select an OLEDB connection.  When I say nothing happens, what I mean is I click on "Import DB Schema...", it closes the menu and goes back to EA.  No windows appear prompting me for database information.

Mark

[hd]

Check you have at least the Professional edition of EA - database engineering is not available in the Desktop edition.

You also need to set up an ODBC driver before you import. For SQL Server 2000, use the SQL Server driver, for SQL Server 2005/2008 use the SQL Native Client.