You can add tables to remote SQL Anywhere databases after they are deployed.
You must be the owner of the publication, or have one of the following:
Context and remarks
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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|