Skip to content

Latest commit

 

History

History
78 lines (58 loc) · 2.24 KB

README.md

File metadata and controls

78 lines (58 loc) · 2.24 KB
Raw

DbSync

Data synchronization utility in tables of two databases

This utility allows you to fix errors in the failure of data replication.

Usage: dbsync [options] TableFile DrvSrc Source DrvDst Destination

Options:

-?, -h, --help   Displays this help.
-v, --version    Displays version information.
-y               Confirm the automatic actions.    
-l               Write down to the log file.
-x               Show differences in tables only.
-u               Ignore rows updating.
-i               Ignore rows adding.
-d               Ignore rows deletion.
-t               Disable trigger execution (off/on).
-m <connections> The number of concurrent database connections (1-20).
-n <limit>       Symbols quantity limit in the log file line (50-999).
-b               Writing additional debugging information.

Arguments:

  TableFile       Path to the table data file.
  DrvSrc,DrvDst   Driver name for connecting to the (source,destination) database: QOCI QPSQL
  Source          Db: user/password@alias or user/password@db[:addr*port]
  Destination     Db: user/password@alias or user/password@db[:addr*port]

TableFile:

  • table columns
  • key table columns
  • name table
  • [condition (where)]
  • [triggers]

note:

  • key table columns - columns to define unique rows;
  • where - process only part of the data in the table;
  • triggers - disabling (replication) triggers during data synchronization.

How to Use:

DbSync is a command line application. You can use it like the following:

  1. Detect the differences in the tables: "dbsync -l -x ..."
  2. Check the log file
  3. Synchronize data in tables: "dbsync -l ..."
  4. Check the log file and the Db

The Examples folder contains examples of tables and the program invocation.

Project building:

  1. qmake -makefile
  2. make (gcc/mingw) or nmake (msvs)

You need:

  • Qt 5 (v.5.11 and higher)
  • compiler: MinGW, GCC, Microsoft Visual C++
  • libraries for the database handling: oracle, postgresql

Folder "DBINSTANCE" (for Windows):

SubFolder "DbInstance\Psql":

  • iconv.dll
  • libeay32.dll
  • libiconv.dll
  • libintl.dll
  • libpq.dll
  • libxml2.dll
  • libxslt.dll
  • ssleay32.dll

SubFolder "DbInstance\Oracle":

  • Files from Oracle instant client