Contents Index Publishing whole tables Publishing only some rows in a table

MobiLink Synchronization User's Guide
  Adaptive Server Anywhere Clients
    Publishing data

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 from Sybase Central or by listing the columns in the CREATE PUBLICATION statement.

Note 

If you create two publications that include the same table with different column subsets, then any user who subscribes to both publications will be unable to synchronize.

To publish only some columns in a table (Sybase Central)

  1. Connect to the remote database as a user with DBA authority using the Adaptive Server Anywhere plug-in.

  2. Open the Publications folder.

  3. From the File menu, choose New > Publication. The Create a New Publication wizard appears.

  4. Type a name for the new publication. Click Next.

  5. On the Tables tab, select a table from the list of Available Tables. Click Add. The table is added to the list of Selected Tables on the right.

  6. On the Columns tab, double-click the table's icon to expand the list of Available Columns. Select each column you want to publish and click Add. The selected columns appear on the right.

  7. Click Finish.

To publish only some columns in a table (SQL)

  1. Connect to the remote database as a user with DBA authority.

  2. Execute a CREATE PUBLICATION statement that specifies the publication name and the table name. List the published columns in parenthesis following the table name.

Example 

The following statement creates a publication that publishes all rows of the id, company_name, and city columns of the customer table:

CREATE PUBLICATION pub_customer (
   TABLE customer (id, company_name,
      city )
)

For more information, see the CREATE PUBLICATION statement.


Contents Index Publishing whole tables Publishing only some rows in a table