Doing Synchronization Using Pervasync Client for Oracle and MySQL

Locate pvc.bat (for Windows) or pvc.sh (for Linux) in the “bin” folder of Pervasync client home. Invoke it with the “-h” option to show its usage:

C:\pervasync\bin>pvc -h

 

Usage

—–

pvc.bat [{sync|refresh|checkin|auto_sync|sys_tray} [<password>]]

 

Use this command to launch the Pervasync Client Configuration and Sync Utility.

If no arguments are specified, i.e.

 

pvc.bat

 

the sync client GUI will be launched.

 

If “sys_tray” is specified as an argument, i.e.

 

pvc.bat sys_tray

 

the sync client GUI will be launched in system tray (minimized).

 

Otherwise, it will run in non-GUI mode.

Use the “sync” sub-command to do two-way sync, e.g.

 

pvc.bat sync

 

Use “refresh” and “checkin” to do one-way sync.

 

You use “auto_sync” option to start the job scheduler for running sync jobs

at pre-arragned times. Use the “Schedule” tab of the GUI to update job schedules.

 

You can optionally supply the sync user password as a second argument.

Stored password will be used if it is absent.

 

Note that the JDBC jar file (for Oracle) or Java connector jar file

(for MySQL) has to be available in folder ../lib to run this script.

If invoked without any arguments, the client will run in GUI mode. In GUI mode, users can start or schedule sync sessions by pointing and clicking.

 

NOTE: You close the GUI window to terminate the client. When you do that, you will be given an option to run the client in system tray. There is also a command-line option “sys_tray” to “pvc.bat” that you can use to launch the client to run directly in system tray. You may want to create a Windows task to do this upon system re-boot. This is useful to run scheduled sync tasks in background.

 

The Sync Tab of the Pervasync Client GUI

Go to the “bin” folder and invoke “pvc.bat” for Windows or “pvc.sh” for Linux. A GUI window will pop up. There are five tabs, Setup, Sync, Schedule, Export and Import. Setup tab is used for setup and reset. Click on Sync tab you will see the following.

Listed below are the GUI settings that need some explanations:

Sync Direction: By default, it’s TWO_WAY sync. You can use “REFRESH_ONLY” and “CHECK_IN_ONLY” to do one-way sync.

Sync User Password: You can optionally supply the sync user password. Stored password will be used if it is absent. You can have the password saved using the setup tab, or use the sync tab and click on the “Save Password” checkbox.

Single Session: When there are sync definition changes in a sync session, Pervasync will only download the definition changes and leave data changes to next sync session. By default, Pervasync will do two sync sessions with one “Sync” button click when there are sync definition changes to make sure both sync definition and data changes are synced. Check this checkbox to perform only one sync session with one click.

NOTE: If sync client resides inside a firewall and sync server resides outside the firewall, you need to set the HTTP proxy host and port using the setup tab with “Advanced Mode” turned on.

You can change the default settings if you need to. Then, click “Sync” to invoke the Sync Agent to do synchronization.

Once the sync session is completed you will see an alert box telling you whether the session succeeded or failed. The “Sync History” panel on the “Sync” tab will also show you a summary of completed sessions.

If the sync fails, first check the error stack trace on the “Sync History” panel. For more detailed debugging info, check the log files under <Pervasync Client Home>/log. If you cannot resolve the issue yourself, send the log file to Pervasync support at support@pervasync.com.

The Schedule Tab of the Pervasync Client GUI

The Schedule tab enables you to schedule up to three sync jobs that do background synchronization at a pre-determined time. In addition to the start time, you also can specify the sync direction and optionally, the sync interval.

Before you schedule background sync jobs, make sure you have the sync user password saved using the “Setup” or the “Sync” tabs.

Click “Schedule” button to start a job and click on “Cancel” button to stop a job. A scheduled sync will be skipped if there is already a sync going on at the scheduled sync start time. Sync history is available on the sync tab.

NOTE: All sync jobs will be cancelled if you exit the sync client.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s