Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
All columns in the primary key must be included in the article.
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.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|