Daca vreti sa folositi replicarea si nu o solutie custom va recomand replicarea de tip Merge.
Puteti citi despre replicare la aceasta adresa: http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/replictn.mspx
Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro