Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Recent Topics
Advanced Search
Same table name in different SQL schema?  
Forum Index -> DB Visual ARCHITECT (DB-VA)
Author Message
dstj


Joined: 2008/03/06
Messages: 1

Offline

Hi,

I'm evaluating DB Visual Architect and find it interesting, but I do have some questions.

I'm using MS SQL 2005 schemas to better "group" my tables. Doing so, I have two tables in different schemas using the same name. For exemple : "Clients.Accounts" and "Accounting.Accounts".

When doing reverse database engineering, only one table is imported. Trying to manually recreate the second table is impossible as DBVA seems to detect that the table name is already in use without considering the different schema name.

Is this a bug or a feature ?

In the Class diagram, I thought that schemas would be converted to namespaces, but it doesn't seem to be the case. Any reason why?

Lastly, an option for displaying schema-qualified names in the ERD would be useful in the above situation...

Thanks,

Dominic.
 
 
   Forum Index -> DB Visual ARCHITECT (DB-VA)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil