Contents Index Publishing only some rows in a table Dropping publications

MobiLink Synchronization User's Guide
  Adaptive Server Anywhere Clients
    Publishing data

Altering existing publications


After you have created a publication, you can alter it by adding, modifying, or deleting articles, or by renaming the publication. If an article is modified, the entire specification of the modified article must be entered.

You can perform these tasks using Sybase Central or with the ALTER PUBLICATION statement.

Notes 

To modify the properties of existing publications or articles (Sybase Central)

  1. Connect to the remote database as a user who owns the publication or as a user with DBA authority.

  2. In the left pane, click the publication or article. The properties will appear in the right pane.

  3. Configure the desired properties.

To add articles (Sybase Central)

  1. Connect to the remote database as a user who owns the publication or as a user with DBA authority using the Adaptive Server Anywhere plug-in.

  2. Open the Publications folder.

  3. Select a publication.

  4. From the File menu, choose New > Article. The Create a New Article wizard appears.

  5. In the Article Creation wizard, do the following:

  6. Click Finish to create the article.

To remove articles (Sybase Central)

  1. Connect to the database as a user who owns the publication or as a user with DBA authority using the Adaptive Server Anywhere plug-in.

  2. Open the Publications folder.

  3. Click the publication.

  4. In the right pane, right-click the article you want to delete and choose Delete from the popup menu.

To modify an existing publication (SQL)

  1. Connect to the remote database as a user who owns the publication or as a user with DBA authority.

  2. Connect to a database with DBA authority.

  3. Execute an ALTER PUBLICATION statement.

Example 

See also the ALTER PUBLICATION statement.


Contents Index Publishing only some rows in a table Dropping publications