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

Two Way Synchronisation – Duplicate Record Number

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Two Way Synchronisation – Duplicate Record Number

Tagged: 

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • August 28, 2012 at 6:54 am #12779
      Peter Brooks
      Member

      I am doing a two way synchronisation. There is a unique Recnum field in all the tables. This is used in making some indexes unique. Both databases can be updated via a program and can end up having the same Recnum allocated. Is there a way when synchronising to allocate another unused Recnum to one of the database tables and indexes to stop the duplicate record?

      Peter Brooks

      http://www.membershipadmin.com.au

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.