Creating a Table Replication Definition

A table replication definition defines a table data source for replication. The table replication definition, maintained by Replication Server, includes information about the columns to be replicated and the location of the primary version of the data.

Open Enterprise Explorer, and connect to your Replication Server.
Expand the view for your Replication Server connection profile, right-click a primary database for which to create the replication definition, and choose New Artifact from the context menu.
From the wizard selection screen, select Table Replication Definition, and click Next to start the wizard.
You can also start this wizard by right-clicking the Table Replication Definitions folder for a primary database and choosing New Table Replication Definition from the context menu.

Specify the primary data location, naming, and display options.

Field	Description
Primary location	Provide values for the following fields: Primary connection profile type: Choose a connection profile type from the drop-down menu. Primary connection profile name: Choose a connection profile name from the drop-down menu. Click Create to create a primary connection profile. Primary server: Select a primary data server from the menu drop-down. Primary database: Select a primary database from the menu drop-down.
Naming	Specify a prefix and suffix for the replication definition: Prefix for RepDef name: Enter a prefix for the table replication definition. By default, this text field contains the connection profile name for your primary Replication Server, followed by an underscore. For example, the default prefix for a primary Replication Server profile named MyRepServer is "MyRepServer_". Suffix for RepDef name: Enter a suffix for the table replication definition. The default suffix is "_rd".
Display	Select a display option: Display all tables: Select this option to display all tables in the primary database. Display marked tables only: Select this option to display only tables that are marked for replication. Display by name pattern: Select this option to display tables according to the name pattern specified in the text field. For example, to display all tables with names that begin with "p", enter p* in the text field, and click Filter.
Table replication definition	Select tables in the grid. Use Select All and Deselect All to select or deselect all tables. Use Invert Selection to revert selections.

Click Next, and set the column replication settings for each selected table.

Field	Description
Replicated tables	The tables selected for replication are displayed in the Replicated tables grid. Columns for the table highlighted in the Replicated tables grid are shown in the Table columns grid that follows.
Table columns	Select columns with the corresponding check boxes, and provide information for the following fields in the Table columns grid, if necessary. By default, all columns are selected. Column: These are the column names for the specified table . You cannot edit this field. Replicate As: Specify the name by which you want this column to be known in the replicate table, which is the table to which this information is replicated. As a default, this field contains the column name of table to be replicated. To modify this value, double-click in the field, and type the desired column name. Datatype: Specify the datatype of the table column. As a default, this field contains the datatype specified in the DDL defining the table. To modify this value, double-click in the field, and select a datatype from the menu drop-down, or enter the datatype. Map To: Specify the datatype to which you want this column to be mapped in the replicate table, which is the table to which this information is replicated. As a default, this field has the column datatype of the table to be replicated. To modify this value, double-click in the field, and select a datatype from the menu drop-down. PKey: Specify the primary key for the replicate table. As a default, the primary key specified is the same as that for the table in the primary database. To modify this value, select the checkbox for each column you want to compose the primary key in the replicate table. Searchable: Select the checkbox for all columns you want to be searchable in the replicate table. Nullible: Select the checkbox for the columns you want to be nullable in the replicate table. Only columns of type text, image, or raw object are nullable. Replicate if Changed: Select the checkbox for all columns you want to be replicated in the event of changes to column data. Only columns of type text, image, or raw object have a check box for this field. Click Invert Selection to invert the status for selected columns. Use Select All or Deselect All for the entire list.

Field

Description

Replicated tables

The tables selected for replication are displayed in the Replicated tables grid. Columns for the table highlighted in the Replicated tables grid are shown in the Table columns grid that follows.

Table columns

Select columns with the corresponding check boxes, and provide information for the following fields in the Table columns grid, if necessary. By default, all columns are selected.

Column: These are the column names for the specified table . You cannot edit this field.
Replicate As: Specify the name by which you want this column to be known in the replicate table, which is the table to which this information is replicated. As a default, this field contains the column name of table to be replicated. To modify this value, double-click in the field, and type the desired column name.
Datatype: Specify the datatype of the table column. As a default, this field contains the datatype specified in the DDL defining the table. To modify this value, double-click in the field, and select a datatype from the menu drop-down, or enter the datatype.
Map To: Specify the datatype to which you want this column to be mapped in the replicate table, which is the table to which this information is replicated. As a default, this field has the column datatype of the table to be replicated. To modify this value, double-click in the field, and select a datatype from the menu drop-down.
PKey: Specify the primary key for the replicate table. As a default, the primary key specified is the same as that for the table in the primary database. To modify this value, select the checkbox for each column you want to compose the primary key in the replicate table.
Searchable: Select the checkbox for all columns you want to be searchable in the replicate table.
Nullible: Select the checkbox for the columns you want to be nullable in the replicate table. Only columns of type text, image, or raw object are nullable.
Replicate if Changed: Select the checkbox for all columns you want to be replicated in the event of changes to column data. Only columns of type text, image, or raw object have a check box for this field.

Click Invert Selection to invert the status for selected columns. Use Select All or Deselect All for the entire list.

Specify save and execution properties.

Field	Description
Generate script	Select this option to generate the script for the table replication definition.
Execute immediately	Execute the SQL immediately. If you do not select this option, you must complete execution of the SQL later to create the table replication definition.

Click Finish to close the wizard.