Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » SQL Anywhere clients » Publications

 

Publishing only some columns in a table

You can create a publication that contains all the rows, but only some of the columns of a table.

Prérequis

There is an existing remote database and you have the SYS_REPLICATION_ADMIN_ROLE system role.

Contexte et remarques

Note

  • 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.

 Task

  1. Connect to the remote database using the SQL Anywhere 16 plug-in.

  2. Double-click Publications.

  3. Click File » New » Publication.

  4. In the What Do You Want To Name The New Publication field, enter a name for the new publication. Click Next.

  5. Click Next.

  6. On the Available Tables list, select a table. Click Add.

  7. Click Next.

  8. In the Available Columns list, expand the list of available columns. Select a column and click Add.

  9. Click Finish.

Résultat

The selected columns are published.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0