Use the SQL Anywhere 12 plug-in to connect to the consolidated database as a user with DBA authority.

In the left pane, select the Publications folder.

Choose File » New » Publication.

In the What Do You Want To Name The New Publication field, type a name for the publication. Click Next.

Click Next.

In the Available Tables list, select a table. Click Add.

Click Finish.

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

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