ASA Data Sync online Help

Command line options

ASA Data Sync supports a number of command line options that make it possible to fully automate database comparison and synchronization. To generate the command line automatically, load the project to be used or specify the comparison options and click More > Generate command line. To log the synchronization process, check the corresponding option and set the Log file name.

Sets the wizard to save the synchronization script to a file, requires the script file name.

-l|log

Enables logging, requires the log file name.

-ig|ignore_case

Sets the wizard to ignore case in strings on data comparison.

-is|ignore_trailling_spaces

Specifies the wizard to ignore trailing and leading spaces on data comparison.

-h|help

Shows help information.

-u|update

-i|insert

-d|delete

Specify whether the wizard will only update target records, insert missing records into target table, or delete rows existing in the target table but not in the source one. If none of these options is specified all differences will be synchronized.

Note: One of sync_db and sync_script is required.

Examples

The examples below assume that you are entering the command lines in the ASA Data Sync program directory. Don't forget to enclose all paths and filenames containing spaces in quotes.

New version features an ability to select or disable certain synchronization operations, executing SQL scripts before and after processing each table, a brand new start page, connectivity enhancements, and some other useful things.

Major features of the new version include comparison of database views and subsets of data, automatic checking of mappings, and exporting the comparison results to 18 file formats including Excel and HTML.