Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Transfers with xml between 2 servers

 
chiranjeevi bigboss
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • 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.

------------------
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • 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
 
Fred Abbot
Ranch Hand
Posts: 300
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • 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
  • 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,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic