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'.

Synchronization profiles define how a SQL Anywhere database synchronizes with the MobiLink server. For a list of the synchronization profile options supported by SQL Anywhere, see CREATE SYNCHRONIZATION PROFILE statement [MobiLink].

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''}';