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

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.

• CREATE SYNCHRONIZATION PROFILE statement [UltraLite]
• ALTER SYNCHRONIZATION PROFILE statement [UltraLite]
• DROP SYNCHRONIZATION PROFILE statement [UltraLite]
• ULSetSynchronizationCallback method [UltraLite Embedded SQL]

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 'publications=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 'publications=p2;uploadonly=on';