SQL Server Performance Forum – Threads Archive
trans. rep. – sql2kI have 220,000 records in a published database.
this data originated from 120 different sources. (FTP –> DB) each of these sources want to specify exactly when their published data is sent to the subscribers. i have one publisher and 4 subscribers. is this possible? the records are marked with an "uploadedby" field.
Hello, My understanding is that you have one publisher and 4 subscriber and You want to publish data to subscriber only when your publisher data gets updated. If my understanding is correct then you can set transaction replication where in log reader will monitor log file for any insert,update and delete. Based on updation, you can published the data to 4 subscriber and it is workable in SQL server. Please read this in books online.
transactional replication, cleaning up Thanks and regards