Creating publications

You create publications based on existing tables in the consolidated database. Use the following procedures to create publications that consist of all the columns and rows in a table.

 Publish tables (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the consolidated database as a user with DBA authority.

  2. In the left pane, click 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. Click Next.

  6. In the Available Tables list, click a table. Click Add.

  7. Click Finish.

 Publish tables (SQL)
  1. Connect to the consolidated 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.

    For example, the following statement creates a publication that publishes the entire Customers table:

    CREATE PUBLICATION PubCustomers (
       TABLE Customers
    );

    The following statement creates a publication that publishes the entire SalesOrders, SalesOrderItems, and Products tables:

    CREATE PUBLICATION PubSales (
       TABLE SalesOrders,
       TABLE SalesOrderItems,
       TABLE Products
    );
 See also