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.

To publish tables (Sybase Central)

1. Connect to the consolidated database as a user with DBA authority.

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

3. Choose 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, select a table. Click Add.

7. Click Finish.

To 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. See CREATE PUBLICATION statement [MobiLink] [SQL Remote].

   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 );