Use the Mark/Unmark Stored Procedures wizard to change the replication status of one or more stored procedures.
Prerequisites Make sure the Replication Server is running. Create and establish a connection to the server.
- Expand your Replication Server connection to display the connector nodes.
- Right-click a connector node, and choose Mark/Unmark Stored Procedures.
- Specify settings to display the replicate status of stored procedures in the primary database.
| Setting |
Description |
|---|
| Primary Location
|
Specify a primary connection profile type, a primary connection profile name, the name of the primary server, and the name of the primary database.
Click Create to create a primary connection profile. |
| Display
|
Select a table display option:
- Display All Stored Procedures – display all stored procedures
in the primary database.
- Display Marked Stored Procedures – display
only stored procedures
that are marked for replication.
- Display Unmarked Stored Procedures – display
only stored procedures
that are not marked for replication.
- Display Stored Procedures
by Name Pattern – display
stored procedures
according to the specified name pattern. For example, to display all stored procedures
with names that begin with "p", enter p* and click Filter.
|
| Select Stored Procedures
|
Select stored procedures in the list, and click Mark or Unmark to change the replication status. Click Invert Selection to invert the status for selected stored procedures.
|
- 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. |