Use this statement to change a SQL Anywhere synchronization profile. Synchronization profiles define how a SQL Anywhere database synchronizes with the MobiLink server.
ALTER SYNCHRONIZATION PROFILE name { REPLACE | MERGE } string
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'.
See CREATE SYNCHRONIZATION PROFILE statement [MobiLink] for a list of the synchronization profile options supported by SQL Anywhere.
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’ |
Must have DBA authority.
Automatic commit.
SQL/2003 Vendor extension.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |