You can create a publication that contains all the rows, but only some of the columns of a table.
There is an existing remote database and you have the SYS_REPLICATION_ADMIN_ROLE system role.
Context and remarks
If you create two publications that include the same table with different column subsets, then you may only create a synchronization subscription for one of them.
An article must include all the primary key columns in the table.
Connect to the remote database using the SQL Anywhere 16 plug-in.
Click File » New » Publication.
In the What Do You Want To Name The New Publication field, enter a name for the new publication. Click Next.
On the Available Tables list, select a table. Click Add.
In the Available Columns list, expand the list of available columns. Select a column and click Add.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|