Chat now with support
Chat with Support

SharePlex 9.2.3 - Installation and Setup for SQL Server Source

About this Guide Conventions used in this guide SharePlex pre-installation checklist Download the SharePlex installer Install SharePlex on Linux and UNIX Install SharePlex on Windows Assign SharePlex users to security groups Set up replication between SQL Server databases Set up replication from SQL Server to a different target type Generic SharePlex demonstration-all platforms Solve Installation Problems Database Setup Utilities General SharePlex Utilities Uninstall SharePlex Advanced installer options Install SharePlex as root Run the installer in unattended mode SharePlex installed items

Change Partitioned Replication

You can change a horizontally partitioned or vertically partitioned replication configuration while replication is active. Both of these procedures require the reactivation of the active replication configuration, but SharePlex only locks tables that are associated with those changes.

Supported databases

Oracle or SQL Server source

All targets

To change horizontally partitioned replication

  1. Run sp_ctrl.
  2. Issue one of the following commands to change the partition or partition scheme. For syntax and other information, see the alphabetical command listings in the SharePlex Reference Guide.

    Command Auth. level Description

    add partition

    2 Creates partition schemes and row partitions.

    drop partition

    2 Removes a row partition from a partition scheme.

    drop partition scheme

    2 Removes a partition scheme.

    modify partition

    2 Modifies a row partition of a partition scheme.
  3. If you dropped a partition scheme:

    1. Copy (but do not deactivate) the active configuration file to a new file.

      sp_ctrl> copy config filename to newname

    2. Edit the copy to remove or change the routing map where the partition scheme was specified.

      sp_ctrl> edit config filename

  4. Activate the new configuration file.

    sp_ctrl> activate config filename

To change vertically partitioned replication

  1. Make a copy of (but do not deactivate) the active configuration file.

    sp_ctrl> copy config filename to newname

  2. Edit the copy to change the appropriate column partition.

    sp_ctrl> edit config filename

  3. Activate the new configuration file.

    sp_ctrl> activate config filename

Related Documents