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

SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Installation Design » Publishing data

Publishing data Next Page

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 database as a user with DBA authority.

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

  3. From the File menu, choose New > Publication.

    The Create Publication wizard appears.

  4. Type a name for the 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 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.

  3. Example

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