Automatic update of database

[sureshhs]

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

[Zim327]

From SQL 2000 Enterprise Manager go to the Tools menu and select replication.
You can also read about replication in the sql help files (Books Online).
If you only have read access to DB1 and DB2 then you'll probably have to work with the owner of DB1,2 and have them set up the replication for you.

HTH,

[sureshhs]

Thanks for the reply. I see that in replication the data gets updated depending on original database. But when the records are deleted in DB1 or DB2, I don't want them to get deleted in my MASTER database. Instead I will have an extra column in MASTER Db, that says that they were deleted in original databases.

Any pointers will be really appreciated.

Thanks,
Mamatha