RE: oracle to informix ddl conversion

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Marichamy, Udaykumar — Wed, 1 Sep 1999 08:41:43 -0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BEF47F.B9FA8150 Content-Type: text/plain Great idea. But does this assume that both the source and target databases exist prior to conversion. What if we are migrating from Oracle to Informix, and we dont have an Informix database yet. Will the tools create the Informix schema file, which I can then use to create the Informix database and tables and other objects? Thanks in advance. Uday -----Original Message----- From: richard@starjump.org [mailto:richard@starjump.org] Sent: Wednesday, September 01, 1999 6:17 AM To: informix-list@iiug.org Subject: Re: oracle to informix ddl conversion On Wed, 25 Aug 1999 11:09:38 -0700, Edward Rosenthal <erosenthal@mfi.com> wrote: >This is a multi-part message in MIME format. >--------------7235C052992E537487994955 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >any body know where i can find a converter program ? >input would be oracle table description, output would be informix ddl. >I'm half way thru writing it and think somebody has already done it? Some sort of CASE tool that handles Entity-Relationship (ER) modelling would be appropriate. The two that spring to mind are ErWin and PowerDesignor DataArchitect (the latter from Sybase), but there are others. These will take a Database creation script from one database, reverse engineer it into an ER model, then you can select a different database system, and create the appropriate sql file. You can even connect to your servers using ODBC, and generate the model/create the database without going via script files. I think you can get 30 day demos of both of these. HTH Richard. ------ =_NextPart_001_01BEF47F.B9FA8150 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.1960.3"> <TITLE>RE: oracle to informix ddl conversion</TITLE> </HEAD> <BODY> Great idea. But does this assume that both the source = and target databases exist prior to conversion. What if we are = migrating from Oracle to Informix, and we dont have an Informix = database yet. Will the tools create the Informix schema file, which I = can then use to create the Informix database and tables and other = objects? Thanks in advance. Uday -----Original Message----- From: richard@starjump.org [<A = HREF=3D"mailto:richard@starjump.org" = TARGET=3D"_blank">mailto:richard@starjump.org</A>] Sent: Wednesday, September 01, 1999 6:17 AM To: informix-list@iiug.org Subject: Re: oracle to informix ddl = conversion On Wed, 25 Aug 1999 11:09:38 -0700, Edward = Rosenthal <erosenthal@mfi.com> wrote: >This is a multi-part message in MIME = format. >--------------7235C052992E537487994955 >Content-Type: text/plain; = charset=3Dus-ascii >Content-Transfer-Encoding: 7bit > >any body know where i can find a converter  = program ? >input would be oracle table description, output = would be informix ddl. >I'm half way thru writing it and think somebody = has already done it? Some sort of CASE tool that handles = Entity-Relationship (ER) modelling would be appropriate. The two that spring to mind = are ErWin and PowerDesignor DataArchitect (the latter from = Sybase), but there are others. These will take a Database creation script = from one database, reverse engineer it into an ER model, then you can = select a different database system, and create the appropriate sql = file. You can even connect to your servers using ODBC, and generate the = model/create the database without going via script files. I think you = can get 30 day demos of both of these. HTH Richard. </BODY> </HTML> ------ =_NextPart_001_01BEF47F.B9FA8150--

↪ replying to Marichamy, Udaykumar

Richard Thomas — Mon, 06 Sep 1999 16:45:26 GMT — source: Informix-list mailing list archive (1991-1998)

On Wed, 1 Sep 1999 08:41:43 -0500, "Marichamy, Udaykumar" <Uday.Marichamy@usoncology.com> wrote: > > >Great idea. But does this assume that both the source and target >databases exist prior to conversion. What if we are migrating from >Oracle to Informix, and we dont have an Informix database yet. Will the >tools create the Informix schema file, which I can then use to create >the Informix database and tables and other objects? > Hi Uday, Sorry, I was getting a little carried away when I said connect via ODBC to create your new database! To answer your question, yes, both tools I mentioned will create the sql file that will create your database in Informix. Richard. PS Please could you stop posting in HTML? Thanks.

RE: oracle to informix ddl conversion

Related threads

Your privacy choices