Book a Demo

Author Topic: Import DB schema from SQL Server: no table listed  (Read 4162 times)

e.martin

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Import DB schema from SQL Server: no table listed
« on: January 22, 2010, 07:43:39 pm »
Hello

I'm using EA 7.5.849. I have a problem using reverse engineering feature to import a DB schema. When I use this function, EA gets the stored procedures but no table.

Databases I want to import are SQL server 2005 and 2008. I can connect to those databases through SQL Server Management studio with the same parameters as given into ODBC datasource configuration.
I've tried "SQL Native Client", "SQL Server" and "SQL Server Native Client 10.0".

Could you help me please ?
Emmanuel
« Last Edit: January 22, 2010, 08:18:09 pm by e.martin »

e.martin

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import DB schema from SQL Server: no table
« Reply #1 on: January 22, 2010, 08:26:57 pm »
More precisely, I can't get table of schemas. I can only have table which are in master db.
« Last Edit: January 22, 2010, 08:36:06 pm by e.martin »

e.martin

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: Import DB schema from SQL Server: no table lis
« Reply #2 on: January 22, 2010, 09:23:24 pm »
I finally found a solution (maybe this is the solution): I have created one odbc datasource by schema on the server.

Is there any other way to access all table without doing this ?