CREATE SYNCHRONIZATION PROFILE statement [MobiLink]

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

Synchronization profiles are named collections of synchronization options that can be used to control synchronization.

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 's=mysub;e={ctp=tcpip;adr=''host=localhost;port=2439''}'

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Automatic commit.

• ANSI/ISO SQL Standard

  Not in the standard.