permissible,while other changes are restrictive, and must be avoided.
Thefollowing changes must be avoided, except under the conditions stated:
♦Changethe publisher for the consolidated database.
♦Makerestrictive changes to tables, such as dropping a column or altering
acolumn to not allow NULL values. Changesthat include the column or
includingNULL entries may already be being sent in messages around
theSQL Remote setup, and will fail.
♦Altera publication. Publication definitions must be maintained at both
localand remote sites, and changes that rely on the old publication
definitionmay already be being sent in messages around the
SQLRemote setup.
Youcan make permissive changes, such as adding a new table or column,
aslong as you use passthrough to ensure that the new table or column
existsin the remote database and in the publication at the remote
database.
♦Dropa subscription. This can be done only if you use passthrough
deletesto remove the data at the remote site.
♦Unloadand reload anAdaptive Server Anywhere database.
Ifan Adaptive Server Anywhere database is participating in replication, it
cannotbe unloaded and reloaded without re-synchronizing the database.
Replicationis based on the transaction log, and when a database is
unloadedand reloaded, the old transaction log is no longer available. For
thisreason, good backup practices are especially important when
participatingin replication.
AnAdaptive Server Enterprise database can be unloaded and reloaded as
longas the system is quiet and the transaction log is fully scanned. The
page_idand row_id rows in the sr_queue_state table of the stable queue
mustbe reset.
188