Dropping Multiple Replication Server Artifacts

Remove multiple artifacts from a Replication Server.

Open Enterprise Explorer, and connect to your replicate Replication Server.
Expand the view for your Replication Server connection profile, and expand the view for the replicate database containing the replication artifacts you want to drop.
Hold the Ctrl key, and select the artifacts you want to drop.
Release the Ctrl key, right-click a selected artifact, and select Drop.

In the Drop Multiple Artifacts wizard, set options in the Articles & Publications tab.

Option	Description
Drop Options	Drop related replication definitions with a publication. Click Restored Defaults to restore current defaults. To save the drop options as preference defaults, click Save As Defaults.
Selected Articles & Publications	Select articles and publications for dropping: Use Filter by Name Pattern to display articles and publications according to the name pattern specified in the text field. For example, to display all articles and publications with names that begin with "p", enter `p*` and click Filter. In the Articles & Publications List grid, select articles and publications for dropping. To change the Drop Option setting for a selected article or publication, click in the corresponding column, and select another option from the menu drop-down. Use Select All and Deselect All to select or unselect all listed articles and publications. Use Invert to invert selections.

Option

Description

Drop Options

Drop related replication definitions with a publication. Click Restored Defaults to restore current defaults. To save the drop options as preference defaults, click Save As Defaults.

Selected Articles & Publications

Select articles and publications for dropping:

Use Filter by Name Pattern to display articles and publications according to the name pattern specified in the text field. For example, to display all articles and publications with names that begin with "p", enter p* and click Filter.
In the Articles & Publications List grid, select articles and publications for dropping. To change the Drop Option setting for a selected article or publication, click in the corresponding column, and select another option from the menu drop-down.

Use Select All and Deselect All to select or unselect all listed articles and publications. Use Invert to invert selections.

Set options in the Subscriptions tab.

Option	Description
Drop Options	Specify purge options: Choose an option for dropping Without Purge: Without Suspension – drop subscriptions without the with suspension option. With Suspension – leave the connection to the replicate database suspended when drop subscription has completed, so you can manually remove rows. With Suspension at Active Replicate Only – for warm standby applications, this option suspends the active replicate database but not the standby replicate database. Choose an option for dropping With Purge: Incrementally – dematerialization occurs in row increments of deletes-per-transaction. Nonincrementally – nonincremental dematerialization. Click Restored Defaults to restore current defaults. To save the drop options as preference defaults, click Save As Defaults.
Selected Subscriptions	Select subscriptions for dropping: Use Filter by Name Pattern to display subscriptions according to the name pattern specified in the text field. For example, to display all subscriptions with names that begin with "p", enter `p*` and click Filter. In the Subscriptions List grid, select subscriptions for dropping. To change the Drop Option, Suspension Option, or Incremental Option setting for a selected subscription, click in the corresponding column, and select another option. Use Select All and Deselect All to select or unselect all listed subscriptions. Use Invert to invert selections.

Option

Description

Drop Options

Specify purge options:

Choose an option for dropping Without Purge:
- Without Suspension – drop subscriptions without the with suspension option.
- With Suspension – leave the connection to the replicate database suspended when drop subscription has completed, so you can manually remove rows.
- With Suspension at Active Replicate Only – for warm standby applications, this option suspends the active replicate database but not the standby replicate database.
Choose an option for dropping With Purge:
- Incrementally – dematerialization occurs in row increments of deletes-per-transaction.
- Nonincrementally – nonincremental dematerialization.

Click Restored Defaults to restore current defaults. To save the drop options as preference defaults, click Save As Defaults.

Selected Subscriptions

Select subscriptions for dropping:

Use Filter by Name Pattern to display subscriptions according to the name pattern specified in the text field. For example, to display all subscriptions with names that begin with "p", enter p* and click Filter.
In the Subscriptions List grid, select subscriptions for dropping. To change the Drop Option, Suspension Option, or Incremental Option setting for a selected subscription, click in the corresponding column, and select another option.

Use Select All and Deselect All to select or unselect all listed subscriptions. Use Invert to invert selections.

Set options for other artifacts in the Others tab.

Option	Description
Filter by name pattern	Use Filter by Name Pattern to display subscriptions according to the name pattern specified in the text field. For example, to display all subscriptions with names that begin with "p", enter `p*` and click Filter.
Other Artifacts List	Select other artifacts for dropping: The Name column displays the artifact name. The Type column displays the artifact type. Use Select All and Deselect All to select or unselect all listed artifacts. Use Invert to invert selections.

Click Next, and specify save and execution properties.

Field	Description
Generate Script	Generate a SQL file for the changes to replication status.
Enter or Select the Parent Folder	Specify an existing project or create a new project in which to save the SQL file.
File Name	Enter the file name in which to store the SQL code.
Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must complete execution of the SQL file later to implement your changes.

Click Finish to drop the artifacts.