Changing Replication Status for Tables

Use the Mark/Unmark Tables wizard to change the replication status of one or more tables.

1. Expand your Replication Server connection to display the connector nodes.
2. Right-click a connector node, and choose Mark/Unmark Tables.
3. Specify settings to display the replicate status of tables 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 Tables – display all tables in the primary database. Display Marked Tables – display only tables that are marked for replication. Display Unmarked Tables – display only tables that are not marked for replication. Display Tables by Name Pattern – display tables according to the specified name pattern. For example, to display all tables with names that begin with "p", enter p* and click Filter.
   Select Tables	Select tables in the list, and select Mark or Unmark to change the replication status. Select Invert Selection to invert the status for selected tables.

4. Click Next, and set the replication mode for text and image columns.

   Field	Description
   Tables with Text/Image Columns	Highlight a table in the grid to display its text and image columns.
   Set Text/Image Column Replication Mode	Select which columns to replicate. In the Replication field, specify a replication mode: Do Not Replicate Always Replicate Replicate If Changed Click Invert Selection to invert the status for highlighted columns.

5. 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.