reverse engineering db views

[Jeb.Beasley]

Is it possible to reverse engineer database views?

I can select tables from the available list but I see no views.  Ideally I would like to reverse engineer from MsSql and regenerate in Oracle!

But, at a minimum I would like to document them via reverse engr.

tnx
jb

[«Midnight»]

JB,

Sometimes you can do the kinds of things you're referring to, but there are pretty clear limits.

As I understand things, the ability to create and reverse engineer views was restricted to Oracle and SQL Server through EA 6.5. As of 7.0 it seems to extend to other DBMS engines.

Still, there seem to be limitations to what you can do. These might well vary by product. Views that simply filter a table, or that represent fairly simple joins seem to work well. As long as you have the SQL for the underlying query you should be OK. I do not know if you'll get into trouble with things like Order By clauses, or anything else that the DBMS engine might not preserve in a view definition.

As far as reverse engineering a view, then forward engineering it to another product, you may be in a bind. Try it with Build 812 if you can. See if EA will preserve the SQL for the source query, and whether you can then transfer it to the target product. Remember that any SQL must be in a common dialect, since EA is unlikely to perform the translation.

David