From: Deepak Vohra <dvohra09@...>
Date: 2007-12-10T11:52:23+09:00
Subject: Re: Database to xml for data migration

--0-3147221-1197254926=:4982
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

XML output may be generated from database query using DBI::Utils::XMLFormatter module.
   
  Refer Listing 5.
  http://www.oracle.com/technology/pub/articles/marx-ruby.html

Cameron Senior <cs.subscribe@gmail.com> wrote:
  Hi Everyone,

I have searched google for answers and have gone down a few paths of
investigation.... But being a newbie I am rapidly getting confused and
this should essentially be a very simple task.

What I need is some advice on the best way to go about this problem.

We are needing to generate XML documents for a migration into a new
system from an existing database.

I looked into the ruby builder library, but couldn't see too many
examples outside of rails to build the XML up from a template. I know I
can put together a rails app to use an rxml template etc, but going down
that path seems to much effort for this....

I have a template of the xml I need to upload, what I need is to
populate that template for each db record. What is the simplest, best
ruby way to export from the db into xml?

Thanks for your help!
-- 
Posted via http://www.ruby-forum.com/.



--0-3147221-1197254926=:4982--