Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Multiple SJA Questions

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #8345
      paulm
      Member

      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

    • #15514
      paulm
      Member

      At this time SJA only permits synchronization in one direction.

    • #15515
      Shadow
      Member

      You can set up two jobs to tackle mutual synchronization. SJA does not perform any checks on the PKs.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.