CREATE SYNCHRONIZATION PROFILE statement [MobiLink]

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

Syntax

CREATE [ OR REPLACE ] SYNCHRONIZATION PROFILE name string

Parameters

OR REPLACE clause Specifying CREATE OR REPLACE SYNCHRONIZATION PROFILE replaces the definition of the named synchronization profile if it already exists.
name Specifies the name of the synchronization profile to create. Each profile must have a unique name.
string Specify a valid option string as described below. Option strings are specified as semicolon delimited lists of elements of the form <option name>=<option value>. For example subscription=s1;verbosity=high.

Remarks

For a listing of the synchronization profile options supported by dbmlsync, see MobiLink synchronization profiles.

For options that take a Boolean value, setting the value to TRUE is equivalent to specifying the corresponding option on the command line.

The following values can be used to specify TRUE: TRUE, ON, 1, YES.

The following values can be used to specify FALSE: FALSE, OFF, 0, NO.

When setting extended options, use the following syntax:

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

Permissions

Side effects

Standards and compatibility

Discuss this page in DocCommentXchange.