Book a Demo

Author Topic: Support for MS SQL 2005 Schemas in DB Model  (Read 2240 times)

MarianAtGreenlight

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Support for MS SQL 2005 Schemas in DB Model
« on: October 01, 2009, 01:17:29 am »
We use in our MS SQL 2005 database tables witch are separated to different schemas, not just the default dbo schema/owner. All our tables have name [SchemaName].[TableName] e.g. Product.Category. Some of the table names are used in two different schemas e.g. there is table Product.Category and Sales.Category.

Is there some way how can I create DB Model diagram which supports this? I need to be able to do both operations reverse and forward engineering.

I tryed reverse engineering in lates trial version of Enterprise Architect but it created table Category just once. Other occurances of the table were ignored.