Create, Modify, and Delete Publications and Articles (Replication)

This section of the documentation contains procedural information about tasks related to creating publications and defining articles.

In This Section

• Create a Publication

• Define an Article

• View and Modify Publication Properties

• View and Modify Article Properties

• Delete a Publication

• Delete an Article

• Create a Publication from an Oracle Database

• Set the Expiration Period for Subscriptions

• Specify Schema Options

• Replicate Schema Changes

• Manage Identity Columns

• Set the Compatibility Level for Merge Publications

Snapshot Options

• Specify Snapshot Format (SQL Server Management Studio)

• Specify an Alternate Snapshot Folder Location (SQL Server Management Studio)

• Compress Snapshot Files (SQL Server Management Studio)

• Configure Snapshot Properties (Replication Transact-SQL Programming)

• Execute Scripts Before and After a Snapshot Is Applied (SQL Server Management Studio)

• Deliver a Snapshot Through FTP

Filtering Data

• Define and Modify a Column Filter

• Define and Modify a Static Row Filter

• Define and Modify a Parameterized Row Filter for a Merge Article

• Optimize Parameterized Row Filters

• Define and Modify a Join Filter Between Merge Articles

• Automatically Generate a Set of Join Filters Between Merge Articles (SQL Server Management Studio)

Transactional Replication Options

• Set the Propagation Method for Data Changes to Transactional Articles

• Set Queued Updating Conflict Resolution Options (SQL Server Management Studio)

• Publish the Execution of a Stored Procedure in a Transactional Publication (SQL Server Management Studio)

Merge Replication Options

• Define a Logical Record Relationship Between Merge Table Articles

• Specify the Processing Order of Merge Table Articles (Replication Transact-SQL Programming)

• Specify That a Merge Table Article is Download-Only

• Specify That Deletes Should Not Be Tracked For Merge Articles (Replication Transact-SQL Programming)

• Specify the Conflict Tracking and Resolution Level for Merge Articles

• Specify a Merge Article Resolver

• Specify Interactive Conflict Resolution for Merge Articles

Zobacz także

Inne zasoby

Publish Data and Database Objects