Generating schema-XML from existing table

[sbelt <sb...@velos.com>]

I know this was asked/answered a few months ago, I just cannot find the
message in the email archives. So I apologize for this interuption:

I have an existing service I would like to move over to Turbine. I already
have many tables in an Oracle server that I would like to use to create the
db-schema XML file. (I want to abandon my Oracle dependency when I make the
switch). A while back, someone responded to a post that the TDK(?) had a
tool/utility which would read a db and generate the XML. I could then use
this XML with Torque to setup a new db.

Has my memory failed me - does this tool exist? Where can I download it? And
does it include docs on how I set it up?

TIA
Steve B.



---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org

Re: Generating schema-XML from existing table

[Heiko Braun <he...@fork.de>]

theres is a build target in 'build.xml',
which (i think) does the job:

 <!-- ===================================================================
-->
  <!-- S Q L  ->  X M L
-->
  <!-- ===================================================================
-->
  <!--  inputFile: The input sql file. This must be valid sql file but
-->
  <!--             it not not be in any specific format.
-->
  <!-- outputFile: The file where the xml schema will be written
-->
  <!-- ===================================================================
-->

  <target name="sql2xml">

    <sql-xml
      inputFile="${schemaDirectory}/schema.sql"
      outputFile="${schemaDirectory}/schema.xml"
    />

  </target>


hope that helps,

heiko

On Mon, 2 Jul 2001, sbelt wrote:

> I know this was asked/answered a few months ago, I just cannot find the
> message in the email archives. So I apologize for this interuption:
>
> I have an existing service I would like to move over to Turbine. I already
> have many tables in an Oracle server that I would like to use to create the
> db-schema XML file. (I want to abandon my Oracle dependency when I make the
> switch). A while back, someone responded to a post that the TDK(?) had a
> tool/utility which would read a db and generate the XML. I could then use
> this XML with Torque to setup a new db.
>
> Has my memory failed me - does this tool exist? Where can I download it? And
> does it include docs on how I set it up?
>
> TIA
> Steve B.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>


 ----------------------------------------------
 heiko braun, fork unstable media [development]


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org