SQL replicaton - collecting data
- by Cicik
Hi,
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)