Contents Index Publishing data Publishing only some columns in a table

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

Publishing whole tables


The simplest publication you can make consists of a single article, which consists of all rows and columns of one or more tables. 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 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 appears in the list of Selected Tables on the right.

  6. Optionally, you may add additional tables. The order of the tables is not important.

  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.

Example 

The following statement creates a publication that publishes the whole customer table:

CREATE PUBLICATION pub_customer (
   TABLE customer
)

The following statement creates a publication including all columns and rows in each of a set of tables from the Adaptive Server Anywhere sample database:

CREATE PUBLICATION sales (
   TABLE customer,
   TABLE sales_order,
   TABLE sales_order_items,
   TABLE product
)

For more information, see the CREATE PUBLICATION statement.


Contents Index Publishing data Publishing only some columns in a table