XML schema generation from/to RDBMS


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: XML schema generation from/to RDBMS

  1. #1
    Donovan Guest

    XML schema generation from/to RDBMS


    Hi,

    Does any one know good tools that will perform automatic XML schema generation
    from/to RDBMS? I cehck both XMLSpy and ERWin but both fall way short of delivering
    this capability.

    Thanks,

    - Donovan Hsieh
    AutoSoft Technology

  2. #2
    Suraj Guest

    Re: XML schema generation from/to RDBMS


    the ADO 2.6 from Microsoft can generate xml out put from a recordset
    <!--

    if Request.ServerVariables( "SERVER_SOFTWARE" ) = "Microsoft-IIS/5.0" then
    RS.Save Response, adPersistXML
    else
    dim objFS, strFilename, strTempFolder, objTextStream
    set objFS = Server.CreateObject( "Scripting.FileSystemObject" )
    strTempFolder = objFS.GetSpecialFolder( TemporaryFolder ) + "\"
    strFilename = objFS.GetTempName()
    'Response.Write strTempFolder + strFilename
    RS.Save strTempFolder + strFilename, adPersistXML
    set objTextStream = objFS.OpenTextFile( strTempFolder + strFilename, ForReading
    )
    dim txt
    txt = objTextStream.ReadAll()
    Response.Write txt
    objTextStream.Close()

    ' NOTE: if you get a Permission Denied message here, you must edit the
    ' DACL for your winnt\temp folder to allow IUSR_MACHINENAME and
    ' IWAM_MACHINENAME to be able to delete temporary files created here
    objFS.DeleteFile strTempFolder + strFilename, False
    end if

    -->
    Suraj

    "Donovan" <dhsieh_9@yahoo.com> wrote:
    >
    >Hi,
    >
    >Does any one know good tools that will perform automatic XML schema generation
    >from/to RDBMS? I cehck both XMLSpy and ERWin but both fall way short of

    delivering
    >this capability.
    >
    >Thanks,
    >
    >- Donovan Hsieh
    > AutoSoft Technology



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center