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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL statement reference

 

UltraLite ALTER SYNCHRONIZATION PROFILE statement

Use this statement to alter an UltraLite synchronization profile. Synchronization profiles define how an UltraLite database synchronizes with the MobiLink server.

Syntax
ALTER SYNCHRONIZATION PROFILE sync-profile-name
{ REPLACE | MERGE } sync-option [; ... ]
sync-option :
sync-option-name = sync-option-value
sync-option-name : string
sync-option-value : string
Parameters
  • sync-profile-name   The name of the synchronization profile.

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

  • sync-option   A string of one or more synchronization option value pairs, separated by semicolons. For example, 'option1=value1;option2=value2'.

  • sync-option-name   The name of the synchronization profile option.

  • sync-option-value   The value for the synchronization profile option.

Remarks

See UltraLite CREATE SYNCHRONIZATION PROFILE statement for a list of the synchronization profile options supported by UltraLite.

Side effects

None.

See also
Example

The following is an example of the ALTER SYNCHRONIZATION PROFILE...REPLACE statement:

CREATE SYNCHRONIZATION PROFILE myProfile1;
ALTER SYNCHRONIZATION PROFILE myProfile1
   REPLACE ‘publication=p1;uploadonly=on’;

The following is an example of the ALTER SYNCHRONIZATION PROFILE...MERGE statement.

CREATE SYNCHRONIZATION PROFILE myProfile2 ‘publication=p1;verbosity=high’;
ALTER SYNCHRONIZATION PROFILE myProfile2 
   MERGE‘publication=p2;uploadonly=on’;