You can change the schema of remote SQL Anywhere databases after they are deployed.
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. See sp_hook_dbmlsync_schema_upgrade.
For more information, see ALTER PUBLICATION statement [MobiLink] [SQL Remote].
Synchronize. Use the new script version, if required.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|