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) » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » Publications and articles

 

Create 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.

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