SQL replicaton - collecting data

I have master SQL server with开发者_运维知识库 DB Central and a lot of satellite SQL servers with DB Client. I need to collect data from log tables(LogTable) on Client(each client has own ID in log table) to one big table on Central(LogTableCentral).

• Data must go only from Client to Central
• On each Client I want to have only data for this Client
• I need solution with minimal amount of work on client side because of count of clients
• Central is MS SQL server Enterprise, Clients are MS SQL server 2005, 2008

Thanks a lot

EDIT: data can be collected periodically(for example: every day at 01:00)

---

As it is done periodically, have you considered using SSIS for this task?

You can add multiple data connections, and then have a series of data sources (each connected to one of the connections) feeding into a data destination (also connected to one of the data sources)

You could then schedule this as part of a SQL Agent Job. Something like this: