Upgrading and resynchronization

Use caution when upgrading a SQL Remote system. You can upgrade a SQL Remote system in any of the following ways:

  • Upgrading software   For information about upgrading SQL Remote, see Upgrading SQL Remote.

  • Changing the database schemas   To make changes to the database schema, you can:

    • Use passthrough mode   The passthrough mode allows schema changes to be sent to some or all databases in a SQL Remote system, but it requires careful planning and execution. See SQL Remote passthrough mode.

    • Re-synchronize subscriptions   Re-synchronization involves copying new copies of the data to the remote databases. When there are many remote databases, resynchronization can be a time-consuming process involving work interruptions and possible data loss. See Resynchronizing subscriptions.


Changes to avoid on a running system