Editing a Replication Definition

Edit a Replication Definition using SQL Scrapbook.

1. Open Enterprise Explorer, and connect to your Replication Server.
2. Expand the view for your Replication Server connection profile, right-click a primary database in which to edit the replication definition, and expand the folder appropriate for the kind of replication definition you want to edit.

   There are folders for Database Replication Definitions, Function Replication Definitions, and Table Replication Definitions.

3. Right-click the replication definition you want to edit, and select Edit from the context menu.

   The replication definition opens in SQL Scrapbook. Both the original replication definition and an automatically generated alter command skeleton display.

4. Edit the command skeleton.
5. Right-click in content window of SQL Scrapbook, and choose the appropriate context-menu option for saving.

   Men option	Description
   Save as Template	Select this option to save the SQL as a template that can be reinserted in future editor sessions. In the New Template wizard: Specify a name and context for the template. Optionally specify a template description. In the Pattern field, manually edit the template definition. Click Insert Variable to generate a list of variables, and select one to insert at the cursor position. When you are finished, click OK to save the new template.
   Save As	Specify project information and a file name in the Save As dialog.
   Save to Server	Select this option to save the artifact to the Replication Server on which it currently resides.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.