Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » MobiLink - Client Administration » SQL Anywhere Clients for MobiLink » SQL Anywhere clients » Publishing data

 

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 Admin mode)
  1. Connect to the remote database as a user with DBA authority, using the SQL Anywhere 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

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 SQL Anywhere sample database:

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