Contents Index Design issues overview Partitioning tables that do not contain the subscription column

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Enterprise
    Publication design for Adaptive Server Enterprise

Conditions for valid articles


All columns in the primary key must be included in the article.

Supporting INSERTS at remote databases 

For INSERT statements at a remote database to replicate correctly to the consolidated database, you can exclude from an article only columns that can be left out of a valid INSERT statement. These are:

If you exclude any column that does not satisfy one of these requirements, INSERT statements carried out at a remote database will fail when replicated to the consolidated database.

Conditions on rows 

There are two ways of including only some of the rows in a publication:

For more information on restrictions on rows, see Creating articles containing some of the rows in a table.


Contents Index Design issues overview Partitioning tables that do not contain the subscription column