Publishing whole tables

The simplest publication you can make consists of a set of articles, each of which contains all the rows and columns in one table. These tables must already exist.

 To publish one or more entire tables (Sybase Central)
  1. Connect to the remote database as a user with DBA authority, using the SQL Anywhere 12 plug-in.

  2. Open the Publications folder.

  3. Choose 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 Finish.

 To publish one or more entire tables (SQL)
  1. Connect to the remote database as a user with DBA authority.

  2. Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.

    See CREATE PUBLICATION statement [MobiLink] [SQL Remote].

 Example