Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (A-D)

 

ALTER SYNCHRONIZATION PROFILE statement [MobiLink]

Use this statement to change a SQL Anywhere synchronization profile. Synchronization profiles define how a SQL Anywhere database synchronizes with the MobiLink server.

Syntax
ALTER SYNCHRONIZATION PROFILE name
{ REPLACE | MERGE } string
Parameters
  • name   The name of the synchronization profile to alter.

  • REPLACE clause   Use this clause to drop the options currently defined for the profile, and add the specified options instead.

  • 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

For a list of the synchronization profile options supported by SQL Anywhere, see CREATE SYNCHRONIZATION PROFILE statement [MobiLink].

When REPLACE is used in the ALTER SYNCHRONIZATION PROFILE statement the entire synchronization profile is replaced with the specified string. This is equivalent to doing a drop then a create. For example:

ALTER SYNCHRONIZATION PROFILE myProfile 
REPLACE 'publication=p1;verbosity=high'

is equivalent to:

DROP SYNCHRONIZATION PROFILE myProfile;
CREATE SYNCHRONIZATION PROFILE myProfile 'publication=p1;verbosity=high'

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

For example, executing the following statements will leave the profile myProfile with the value publication=p2;verbosity=high;uploadonly=on.

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

Must have DBA authority.

Side effects

Automatic commit.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.