Adding tables to deployed SQL Anywhere remote databases

You can add tables to remote SQL Anywhere databases after they are deployed.

Prérequis

You must be the owner of the publication, or have one of the following:

ALTER privilege on the publication
SYS_REPLICATION_ADMIN_ROLE system role

Contexte et remarques

Note

If you can ensure that there are no other connections to the remote database, you can use the ALTER PUBLICATION statement manually to add new or altered tables to your publications. Otherwise, you must use the sp_hook_dbmlsync_schema_upgrade hook to upgrade your schema.

Task

Add the associated table scripts in the consolidated database.

The same script version may be used for the remote database without the new table and the remote database with the new table. However, if the presence of the new table changes how existing tables are synchronized, then you must create a new script version, and create new scripts for all tables being synchronized with the new script version.
Perform a normal synchronization. Ensure that the synchronization is successful before proceeding.
Use the ALTER PUBLICATION statement to add the table. For example:
ALTER PUBLICATION your_pub ADD TABLE table_name;
You can use this statement inside a sp_hook_dbmlsync_schema_upgrade hook.
Synchronize.

Résultat

The tables are added to the remote database.

Suivant

Use the new script version, if required.