Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Uploading data from one database to another

 
David Menfields
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Can you provide me a high level idea to my urgent requirement.

Daily morning say 7 � clock, I need to upload the previous day records(deals) from one database to another database . That should be automatic.

I understand that i need the sql script inside a stored procedure which should be executed automatically. How to automate this?...any trigger can fire this ? or any java program can invoke this script daily?

Thanks.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Which Database are you using...

in order to insert/select into different database you need to have a db link to remote database.
for example if you have Oracle the you can create a job excute it at interval of one day to perform your task, for oracle you have also option of materialized view.

Another option would be perform task in java, make a program to select and insert from one DB to another DB, run it using thread or any other way to repeat at every 24 hour, or you can use some open source schedulr to do your job.Quratz is one schedular which to this task.

Shailesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic