article Properties, Snapshot Tab
TOC
Collapse the table of content
Expand the table of content

article Properties, Snapshot Tab

SQL Server 2000

The following options are available on the Snapshot tab of the article Properties dialog box.

Options

Keep the existing table unchanged

Keep all the existing data and schema in the Subscriber table with the same name as the destination table.

DROP the existing table and re-create it

Delete the Subscriber table that has the same name as the destination table and create a new table locally that is identical to the table at the Publisher.

Delete data in the existing table that matches the row filter statement

Delete the data that matches the data to be replicated from the Publisher in the Subscriber table with the same name as the destination table. Data in the local table that does not match the data to be replicated remains unchanged in the local table.

Delete all data in the existing table

Delete all the data but keep the table schema in the Subscriber table with the same name as the destination table.

Include declared referential integrity

Copy all primary key constraints, reference constraints, and unique constraints to the destination table if they exist on the source table at the Publisher.

Clustered indexes

Copy clustered indexes to the destination table if they exist on the source table at the Publisher.

Nonclustered indexes

Copy nonclustered indexes to the destination table if they exist on the source table at the Publisher.

User triggers

Copy user triggers to the destination table if they exist on the source table at the Publisher.

Extended properties

Copy extended properties to the destination table if they exist on the source table at the Publisher.

Collation

Copy collation specifications to the destination database if they exist on the source database at the Publisher.

Convert user-defined to base data types

Convert the user-defined types to the original data types on which they were based if there are user-defined data types in the source table at the Publisher. Converting user-defined data types to base data types may alter the formatting and other characteristics of the data.

See Also

Applying the Initial Snapshot

Publishing Data and Database Objects

Show:
© 2016 Microsoft