Re: Poring views across Oracle, SQL Server, Informix etc.

Hi!

Try Sybase StarDesignor (they changed the name of this product a few times,

but you should be able to find it at www.sybase.com). Free 60 days trial is

available.

HTH Michael

the_big_bang_at_my-deja.com wrote:

> 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