sql server replication: I am a software developer who has been tasked with setting up replication for one of our clients. I have about 1 week of experience working with replication, so any help would be appreciated.

My situation:
5 databases:
Production - All sales transactions go into here
Corporate - Used to report on everything in the Production DB
Site A - Filtered for Site A data
Site B - Filtered for Site B data
Site C - Filtered for Site C data
All connections must be two-way (Data changed at Site A most propagate back through Corporate to Production, data entered at Production -> Corporate -> Site A\B\C)

I want the Corporate DB to be the publisher and Production, Site A\B\C to be subscribers to keep the load off Production.

The issues I have are:
Filtering the data to Sites A\B\C
Default values are being stripped off columns during replication
Data is not being propagated accuratly (Data entered at production replicated to Corporate, then the data is deleted at Corporate and at Production).

I have tried several combinations of Merge and Transactional Replication and nothing works as needed.

Thanks,
David

---
Posted using Wimdows.net NntpNews Component -

David,

one topology that should solve your issues:

Production publishes everything to Corporate using merge.
Corporate publishes to SitesA-C (3 subscribers) using merge with dynamic
filters.

This setup is known as republishing, as Corporate is both a publisher and a
subscriber.

HTH,

Paul Ibison