ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

ALTER SYNCHRONIZATION SUBSCRIPTION
{ subscription-name | TO publication-name [ FOR ml-username, ...  ] }

alter-clause :
RENAME new-subscription-name
| TYPE network-protocol
| ADDRESS protocol-options
| ADD OPTION option=value, ... 
| ALTER OPTION option=value, ...
| DELETE { ALL OPTION | OPTION option, ... } 
| SET SCRIPT VERSION=script-version

subscription-name : identifier

publication-name : identifier

ml-username : identifier

new-subscription-name : identifier

network-protocol : http | https | tls | tcpip

protocol-options : string

value : string | integer

option : identifier

script-version : string

TO clause This clause specifies the name of a publication.
If the TO clause is used without a FOR clause, you cannot use the RENAME or SET SCRIPT VERSION clauses.
FOR clause This clause specifies one or more MobiLink user names.
Omit the FOR clause to set the protocol type, protocol options, and extended options for a publication.

If the TO clause is used without a FOR clause, you cannot use the RENAME or SET SCRIPT VERSION clauses.
RENAME clause This clause specifies a new name for the subscription.
If the TO clause is used without a FOR clause, you cannot use the RENAME clause.
TYPE clause This clause specifies the network protocol to use for synchronization. The default protocol is tcpip.
ADDRESS clause This clause specifies network protocol options, including the location of the MobiLink server.

Cloud note: You can specify NULL for the protocol-option value for cloud tenant databases.
ADD OPTION, ALTER OPTION, DELETE OPTION, and DELETE ALL OPTION clauses These clauses allow you to add, alter, delete, or delete all extended options. You can specify only one option in each clause. No option is specified for Delete All.
The values for each option cannot contain the characters " = " or " , " or " ; ".
SET SCRIPT VERSION clause This clause specifies the script version to use during synchronization. You can alter the script version without making a schema change.
If the TO clause is used without a FOR clause, you cannot use the SET SCRIPT VERSION clause.

Cloud note: You can specify NULL for the script-version value for cloud tenant databases.

The network-protocol, protocol-options, and options can be set in several places.

This statement causes options and other information to be stored in the SQL Anywhere ISYSSYNC system table. Anyone with DBA authority for the database can view the information, which could include passwords and encryption certificates. To avoid this potential security issue, you can specify the information on the dbmlsync command line.

DBA authority and exclusive access to all tables referred to in the publication.

Automatic commit.

CREATE PUBLICATION statement [MobiLink] [SQL Remote]
DROP PUBLICATION statement [MobiLink] [SQL Remote]
CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]
SQL Anywhere MobiLink clients: Synchronization subscription creation
UltraLite MobiLink clients: UltraLite client synchronization design
ISYSSYNC system table
MobiLink client network protocol options
MobiLink SQL Anywhere client extended options
CommunicationType (ctp) extended option
dbmlsync syntax
Priority order
Script versions

SQL/2008 Vendor extension.

The following example changes the address of the MobiLink server for the sales subscription:

ALTER SYNCHRONIZATION SUBSCRIPTION sales
TYPE TCPIP
ADDRESS 'host=10.11.12.132;port=2439';

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Syntax

Parameters

Remarks

Permissions

Side effects

See also

Standards and compatibility

Example