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.

Keep the following in mind:

  • Publications can be altered only by the DBA or the publication's owner.

  • Be careful. In a running MobiLink setup, altering publications may cause errors and can lead to loss of data. If the publication you are altering has any subscriptions, then you must treat this change as a schema upgrade. See Schema changes in remote MobiLink clients.

 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 appears in the right pane.

  3. Configure the properties.

 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 SQL Anywhere 12 plug-in.

  2. Expand the Publications folder.

  3. Select a publication.

  4. Click File » New » Article.

  5. In the Create Article Wizard, do the following:

    • In the Which Table Do You Want To Use For This Article list, select a table. Click Next.

    • Click Selected Columns and select the columns. Click Next.

    • In the You Can Specify a WHERE Clause For This Article pane, enter an optional WHERE clause. Click Finish.

 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 SQL Anywhere 12 plug-in.

  2. Expand the Publications folder.

  3. Right-click the publication and choose Delete.

  4. Click Yes.

 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. Execute an ALTER PUBLICATION statement.

 See also
 Example
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1