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

Data Sync?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Data Sync?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • November 6, 2004 at 5:19 am #8643
      kelvin
      Member

      Hello,

      Being new to databases I am wonder if SQLyog Job Agent will do what I am looking for.

      Does the structure of the two databes, tables, field names have to be the same in order to syncronize?

      Also when data from the two sources is syncronized does this mean that they are reconciled? example

      Contents of DB1/Table_A/Field_01 = [ 8 ] 2 sold

      Contents of DBa/Table_3/Field_aa = [ 6 ] 4 sold

      Both started with 10

      When syncronized would both now be 6?

      or

      Will they both be 4?

      Thanks

    • November 6, 2004 at 6:07 am #16509
      Ritesh
      Member
      Quote:
      Does the structure of the two databes, tables, field names have to be the same in order to syncronize?

      Yes.

      Quote:
      Both started with 10

      When syncronized would both now be 6?

      or

      Will they both be 4?

      The data from source database will be updated to the target. Assuming that DB1 is the source – the data will be 8 in both source and target after the sync.

    • November 6, 2004 at 5:20 pm #16510
      kelvin
      Member

      Thanks for the feedback.

      Does anyone know if there are any tools or utilities that exist that can reconcile data from two seperate databases?

      TIA

    • November 7, 2004 at 7:30 am #16511
      Ritesh
      Member

      I am not sure about what you mean by data reconciliation.

      Can you explain it with an example? I am sure SQLyog Job Agent will do the job for you.

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