sql server replication: In the Push Subscription Wizard, the only options
are to initialize the schema and data together, or,
to start replication , the subscriber already having
the schema and data. Is it possible to replicate the data
only, the data on the subscriber side having been
truncated or deleted ?

John Yard

Have a look at the article properties. Here you can specify that if a name conflict exists, the table can be truncated. This keeps the schema in place and in your case runs the redundant truncate table command
Regards

Hi John,

No, your only two options are to replicate both the schema and data or the
subscriber already has the schema and data.

The schema is a very small part of replication; most database schemas
replicate very quickly so it should not slow things down.

Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.