Poring views across Oracle, SQL Server, Informix etc.

Hi,

Our applications support Oracle, SQL server etc. We have bunch of views which have to be maintained for all supported databases.

1. Is there any tool which will read the view DLL e.g. for SQL Server and spit out equivalent one for e.g. Oracle ? We have to maintain same view for each database by hand. This will be useful for current scripts. ERWin is not able to convert view from one database to another database.
2. For building future views, is there any tool which will act as a view builder i.e. view definitions will be entered in the tool and it can spit out DDL for SQL Server, Oracle, Informix etc. etc.

TIA, Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 12 2000 - 00:00:00 CEST