Hello,

What is the best solution for the following situation.
There are 2 data bases DB1 & DB2 to which i have only read access.

I have my own MASTER database on which I am admin. I need to fill my MASTER database by reading DB1 & DB2.

I want MASTER to get updated every time there is change in DB1 or DB2. Is something like getting-notifications-when-there-is-change architecture available in SQL. Or do i need to create my own program/service that runs at regular intervals to check for updates from DB1 & DB2. Any other ideas to deal with this kind of situation?

Thanks,
suresh