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 » SQL Remote » Creating SQL Remote systems » Publications and articles

 

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.

Prerequisites

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the consolidated database.

  2. In the left pane, expand the Publications folder.

  3. Click File » New » Publication.

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

  5. In the Choose a Publication Type window, select the appropriate publication type. Click Next.

  6. In the Specify Tables list, click one or more (using Ctrl-click) tables. Click Add.

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

  8. In the Create Upload Procedures window, choose which stored procedures to create, as necessary.

  9. Click Finish.

Results

The publication is created as specified.

Next

Create a subscription.

 See also