Data filtering and replication

When you create a subscription to a particular table (for example, the PATIENTS table for your group of visiting nurses), performance considerations might force you to replicate only a subset of the data in the subscription. You specify this subset by choosing individual rows to be replicated for each table in the subscription.

For example, you might decide that the only columns relevant for visiting nurses using the PATIENTS table are the PATIENT_NAME, ADDRESS, PHONE, and DOCTOR fields. You might then decide to further filter the data by defining a WHERE clause that filters data for nurses working for a particular doctor.

You can combine data filters for the subscription with filters set for the group or for individual users to pare down the data even further.

Související koncepce

Související úlohy