Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Database Transfers with xml between 2 servers

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all...
I want to know how data can be transfered between database servers of two different websites using xml. Can anyone provide me the java implementation of xml(source code if possible). It will be of great help for me if anyone can describe the step-by-step process. I need to write a batch process in java for this task which will be automatically running and transfers the data from one database to the other. Thanx in advance.

------------------
 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi chiranjeevi,
If the 2 websites are using the same database engine, it's likely that the database vendor already provides tools to do this. That would be easier than having to write your own synchronisation system ;-)
By the way, what database engine(s) are you using?
Regards,
Beno�t
 
Ranch Hand
Posts: 300
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oracle
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Then I suggest you use Oracle XSU, which is intended for that purpose. It produces or processes XML files to update a database.
Cheers,
Beno�t
 
chiranjeevi bigboss
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi Beno�� d'Oncieu...
i am using oracle as the database can u plz., tell me how to get started with xsu and also plz., tell me can i write an AUTOMATED batch process for transfering of database along with data from one database server of one website to the database server of another website....i ll be grateful to u if can suggest r explain something abt this to me...
Thanx and regards,
 
Lasagna is spaghetti flvored cake. Just like this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic