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?
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.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein