SYNCHRONIZE {
PROFILE sync-profile-name [ MERGE sync-option [ ;... ] ]
| USING sync-option  [ ;... ]
}

sync-option :
sync-option-name = sync-option-value

sync-option-name : string

sync-option-value : string

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

See ALTER SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ] to understand how sync options are merged with existing options in the synchronization profile.

By allowing sync options to be merged in, developers can choose to omit storing some options in the database (like the MobiLinkPwd for instance).

If a synchronization callback function is defined and registered with UltraLite, whenever a SYNCHRONIZE statement is executed, progress information for that synchronization is passed to the callback function. If no callback is registered, progress information is suppressed.

None.

• ALTER SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ]
• DROP SYNCHRONIZATION PROFILE statement [UltraLite] [UltraLiteJ]
• ULSetSynchronizationCallback method

The following example shows the syntax for synchronizing a synchronization profile called Test1 where the MobiLinkPwd has not been stored as part of the profile:

 SYNCHRONIZE PROFILE Test1 MERGE ''MobiLinkPwd=sql'

The following example shows the syntax for adding the publication and uploadonly options to a synchronization profile called Test1.

SYNCHRONIZE PROFILE Test1
   MERGE'publication=p2;uploadonly=on';

The following example illustrates how to use USING.

SYNCHRONIZE USING ''MobiLinkUid=joe;MobiLinkPwd=sql;ScriptVersion=1;Stream=TCPIP{host=localhost}'

The following example shows the syntax for synchronizing the publication and uploadonly options.

SYNCHRONIZE 
   USING 'publication=p2;uploadonly=on';