Publishing only some columns in a table

Create a publication that contains all of the rows, but only some of the columns, of a table.

Prérequis

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the consolidated database.
In the left pane, expand the Publications folder.
Click File » New » Publication.
In the What Do You Want To Name The New Publication field, type a name for the publication. Click Next.
In the Choose a Publication Type window, select the appropriate publication type. Click Next.
In the Specify Tables list, click one or more (using Ctrl-click) tables. Click Add.
On the Available Columns tab, click the table's icon to expand the list of Available Columns. Click each column you want to publish and click Add. Click Next.
In the Create Upload Procedures window, choose which stored procedures to create, as necessary.
Click Finish.

Résultat

The publication is created as specified.

Suivant

Create a subscription.