Batch Data Synchronization

Use Batch Data Synchronization for synchronizing content of groups of tables, views, virtual tables or stored queries.

Key Points:

  • Data synchronization of the selected pair of objects is one-way. In order to synchronize in both directions, it is necessary to execute two synchronization procedures.
  • Batch Synchronization is used for synchronizing tables, views, virtual tables, and saved queries. Note that only database table or view can serve as the synchronization target object.
  • The user is responsible for selecting the pair of objects meant for synchronization.
  • Data synchronization cosists of two stages:
    1. Comparison for finding the data differences
    2. Synchronization itself - generating the appropriate synchronization script and its execution.
  • At the comparison stage, the program is using same rules and settings that are used for simple data-comparison.
  • The execution of the generated synchronization script can be launched immediately following the conclusion of the synchronization procedure, or it can be postponed and launched later.
  • The user is able to save the synchronization script into a file for further analysis and future use.

The Batch Data Synchronization Procedure:

  1. Select the groups of objects meant for comparison from the left and right panels (Tables, Views, Virtual Tables, Stored Queries):
    Figure 21: Group selection
  2. Use Synchronize > Batch Synchronization menu command
  3. Select and map the objects intended for synchronization in the Batch Synchronization dialog. NOTE:The program maps the objects of the selected groups automatically, on the object names basis. However, the user can manually redefine any object pair for further synchronization.
    Figire 22: Map objects
  4. Select the direction of the synchronization (From Left -> To Right or To Right <- From Left)
    Figure 23: Select synchronization direction
  5. Select the allowable synchronization actions:
    • Insert missing records - Insert/do not insert records that are present in the source table and are absent from the target table.
    • Update different record - Change/do not change field values in differing records.
    • Delete obsolete records - Delete/do not delete records that are present in the target table but are absent from the source table.

    Figure 24: Allowable Synchronization Actions.
  6. Select desired error handling option:
    • Ignore Errors - Ignore any errors, continue the procedure and save the successfully completed changes in the target table.
    • Up to first Error - At the detection of the first error, stop the procedure without saving any changes in the target object.
    • Up to end - Continue the procedure regardless of any errors; however, do not save any changes in the target table if even one error occurs.

    Figure 25: Error handling options
  7. In order to save the generated SQL synchronization script into a file – check the Save synchronization script to file option and set the parameters of the saved file.
    NOTE: the program supports three formats of the synchronization script file:
    • BSQ – binary format
    • Text ASCII
    • Text Unicode

    Figure 26: Storing the SQL Synchronization Script.
  8. In order to create a report on the synchronization procedure – check the Synchronization report box and set the parameters for the report file.
    The program supports two report-file formats: XML and HTML.
    Figure 25: Request for the synchronization report.
  9. Start the synchronization procedure by clicking the Run... button

The program will execute the procedure and create a report (if the appropriate option was selected ).
Figure 27:An example of a synchronization report

© 2013 - 2020 - Because Every Bit Matters | Privacy Policy | Terms of Use