Oninit cdi / Archive
Talk to an expert →

Poring views across Oracle, SQL Server, Informix etc.

Posted in 2000

Topics: General Discussion

the_big_bang@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to the_big_bang@my-deja.com
Michael Krzepkowski — — source: Informix-list mailing list archive (1991-1998)

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@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.

↪ replying to the_big_bang@my-deja.com
Ruud de Koter — — source: Informix-list mailing list archive (1991-1998)

the_big_bang@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/ Take a look at Dezign for Databases at http://www.heraut.demon.nl/. I think this is a promising tool for what you want to do. Regards, Ruud -- -------------------------------------------------------------------------------------- Ruud de Koter HP OpenView Software Business Unit Senior Software Engineer IT Service Management Operation Telephone: +31 (20) 514 15 89 Van Diemenstraat 200 Telefax : +31 (20) 514 15 90 PO Box 831 Telnet : 547 - 1589 1000 AV Amsterdam, the Netherlands Email : ruud_dekoter@hp.com internet: http://www.openview.hp.com/itsm http://www.openview.hp.com/assetview intranet: http://ovweb.bbn.hp.com/itservicemanager --------------------------------------------------------------------------------------