Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » Replication Design for SQL Remote » SQL Remote installation design » Publication design


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:

  • Columns that allow NULL.
  • Columns that have defaults.

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.

The uploaded insert fails because of missing columns.
Using BEFORE triggers as an alternative

An exception to this case is when the consolidated database is a SQL Anywhere database, and a BEFORE trigger has been written to maintain the columns that are not included in the INSERT statement.