• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reverse engineers database into xml

 
Vishwanath GNV
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I need to generate xml file from oracle database. I am looking for open source tool or something like code. So, that I would get some idea, based on them...

Please tell me, how handle this...ASAP
 
Vishal Matere
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XML file generation http://rustemsoft.com/jsps.htm
Does this Help?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4028
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's a non-trivial topic, meaning you have to write a parser yourself. You can get tools that will try to auto-generate a database out of XML, but often the logical structure is lost. For example, you might use database normalization for efficient storage of column data, but in the XML you want these tables denormalized so that a record contains all of its information.

In short, there's no magic solution since database don't necessarily have relationships easily discovered by a general purpose parser. Besides, writing a program that reads a database and outputs XML is good practice and this way you'll have 100% control over how the data is structured in the XML for easy customization.
[ April 22, 2008: Message edited by: Scott Selikoff ]
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One easy way is to use DBUnit through an ANT script. I'm not recommending it, just saying it is possible ( since DB Unit stores its info as XML)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic