Compare DM includes views?

[Thomas Kellerer]

Hi,

I just noticed that when doing a Compare Datamodel against a physical
database, all views are also retrieved from the database.

As PA (unfortunately) does not support modelling of views, I wonder
what the reason for this is?

This gives a lot of wrong "should be added"/"should be removed"
entries when using the english description - or even worse a lot of
"DROP TABLE ..." statements for those views.

Is there a reason why SQLTable.fetchTablesForTableContainer()
retrieves views as well?

Regards
Thomas

[Jonathan Fuerth]

On Sun, Feb 21, 2010 at 12:38 PM, Thomas Kellerer <google...@sql-workbench.net> wrote:

Hi,

I just noticed that when doing a Compare Datamodel against a physical
database, all views are also retrieved from the database.

As PA (unfortunately) does not support modelling of views, I wonder
what the reason for this is?

Well, it was just too much to take on initially. We now have a fairly decent visual query editor in Wabit that could be put into Power*Architect as a view builder. This would work really well for views you build in your playpen and then forward engineer to any combination of target databases.

Unfortunately, we'd still be unable to properly reverse engineer a view: that invokves building a structured understanding of the query behind a view. We have made one attempt at this in the past, but came up short. It's on our "long term nice-to-have" list to look at the problem again. We have some new ideas based on what we learned in the first attempt.

This gives a lot of wrong "should be added"/"should be removed"
entries when using the english description - or even worse a lot of
"DROP TABLE ..." statements for those views.

Is there a reason why SQLTable.fetchTablesForTableContainer()
retrieves views as well?

Only because we anticipate that people might want to drag views into their playpen in order to include them in a database diagram. It's not at all useful for round-trip engineering, and only marginally useful for the "English descriptions" component of Compare DM.

-Jonathan