Replication of structure

Hello

I have a server with SQL Server 2005 and several machines with SQL Server Express.

I have my "master" DB on the SQL Server 2005 on which I have created a transactional publication (push)

Then all my other DB have a subscription to that publication.

I have different scenarios:

The structure needs to be replicated --> OK it works The data of some table needs to be replicated --> OK it works Whatever the data at the client, they are replaced after the replication The data of some table needs to be partially replicated --> OK it works Whatever the data at the client, they are replaced after the replication (only part of the server data is replicated with the filters) Some data must not be replicated --> Don't know how to do this Whatever the data at the client and at the server, I want them unchanged after the replication

Can you help me with this latest point ? I have tried with the filtering but it always remove all data from the client. What I need is: If I have 10 lines on my server, and 20 on my client, I only want the structure to be updated. But I still need my 10 lines on the server and my 20 on my client after the replication.

Thanks !

By default, when you apply the snapshot, it will drop the table(s) at the subscriber and replace it with refreshed data generated by the snapshot. If you don't want the data dropped, then make sure to clear the "initialize" checkbox in the subscription wizard. See topic "How to: Initialize a Subscription Manually".