Synchronization Job between a master database and other readonly databases

I currently have a master database which has certain table that are updated nightly. I also have numerous readonly databases which contains tables from the master. What I need help with is synchronizing these readonly tables data to the master database on any inserts, updates, or deletes. The servers may also sit on different servers than the master database but are on the same network. Is there any way to write a scheduled job which goes and fi开发者_Python百科nds all updates, inserts, and deletes on a table in the master database and (using a primary key for the updates & deletes) perform these operatations on the readonly database?

Thanks

Yes, write an SSIS package and schedule it to run to synchronize the databases.