Information générale
Forum:
Microsoft SQL Server
Marcus,
Yes. Through the wizard, you can filter the replication "vertically" - meaning you can select only certain columns to replicate. However, these fields will not be included in the initial snapshot, so the subscriber tables will not contain those columns.
The way to include those columns in the replication but ignore any changes made to these columns is to replace the auto-generated stored procedures that update the table with your own.
>Hi,
>
>I have one basic question to SQL Server replicaion.
>Is it possible to determine that only a subset of fields in a table should be replicated, and other fields shall not be touched (updated from elsewhere).
>
>Thanks for your help
>Marcus
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement