I would like to use SJA to perform database synchronization between two MySQL databases. One database is on a remote PC. The other database is on a Linux server. Both databases have the same structure. New students records can be added to the student table from both the server and the PC. The primary key for the student table is StudentID. The StudentID is an auto-incrementing field.
How should I set up SJA to accomplish the synchronization?
How would SJA handle an ambiguous StudentID while performing a synchronization?
Thank You,
Paul