ALTER SYNCHRONIZATION PROFILE statement [MobiLink]

Changes a SQL Anywhere synchronization profile. Synchronization profiles are named collections of synchronization options that can be used to control synchronization.

Syntax

ALTER SYNCHRONIZATION PROFILE name
MERGE string

Parameters

name
The name of the synchronization profile to alter.
MERGE clause
Use this clause to change existing, or add new, options to a synchronization profile.
string
A string of one or more synchronization option value pairs, separated by semicolons. For example, 'option1=value1;option2=value2'.

Remarks

Synchronization profiles define how a SQL Anywhere database synchronizes with the MobiLink server.

When MERGE is used in the ALTER SYNCHRONIZATION PROFILE statement, options specified in the string are added to those already in the synchronization profile. If an option in the string already exists in profile, then the value from the string replaces the value already stored in the profile.

For example, executing the following statements leaves the profile myProfile with the value subscription=s2;verbosity=high;uploadonly=on.

CREATE SYNCHRONIZATION PROFILE myProfile 'subscription=p1;verbosity=high';
ALTER SYNCHRONIZATION PROFILE myProfile MERGE 'subscription=p2;uploadonly=on';

When setting extended options, use the following syntax:

ALTER SYNCHRONIZATION PROFILE myprofile MERGE 's=mysub;e={ctp=tcpip;adr=''host=localhost;port=2439''}';

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.