Table 1-2 Oracle GoldenGate Veridata Installation Roadmap

Task	Description	Documentation
Verify your system environment and   install the prerequisites	Before beginning the installation,   verify that the minimum system and network requirements are met.	See  .
Obtain the appropriate distribution   for your installation type	The Oracle GoldenGate Veridata   distribution. For Oracle GoldenGate Veridata 12.2.1.4.0, the installer   is  fmw_12.2.1.4.0_ogg.jar .	See  .
Determine your installation   directories	Verify that the directories that will   need to be created can be created or accessed by the installer, and exist on   systems that meet the minimum requirements.	See   in  Planning an Installation   of Oracle Fusion Middleware.
Install Oracle GoldenGate Veridata	Installing software transfers the   software to your system and creates the Oracle home directory.	For   more information about the install types available during installation,   see  . For   installation instructions, see  .
Create Oracle GoldenGate Veridata   Repository schema.	Use the Repository Creation Utility   (RCU) to create the Repository database schemas.	See  .
Create and configure your domain	Use the configuration wizard to create   and configure your domain.	See   to   create the domain.
Apply patch using OPatch	Use OPatch to apply latest bundle   patch, and execute repository patch if applicable.	See  .

Table 6-1 Directories in an Oracle GoldenGate Veridata Installation

Directory Variable	Directory Path
ORACLE_HOME	/ install_location /Oracle_Home . This is the home directory for the   Oracle Fusion Middleware products.
VERIDATA_PRODUCT_HOME	/ ORACLE_HOME /veridata
AGENT_ORACLE_HOME	/ VERIDATA_PRODUCT_HOME /agent
AGENT_DEPLOY_LOCATION	This   is the location where the Oracle GoldenGate Veridata Agent is deployed. Note   that this location should be outside the  ORACLE_HOME.

l   Oracle, ADW, ATP, DBCS

l   SQL Server

l   MySQL

l   Teradata

l   BigData Hive

l   DB2 for i, DB2 LUW, and DB2 z/OS

l   Informix

l   Non Stop (Enscribe, SQL/MP, SQL/MX)

l   Sybase Adaptive Server Enterprise (ASE)

 

l   Oracle GoldenGate Veridata supports the following databases for repair functionality:

ü   Oracle, ADW, ATP, DBCS

ü   SQL Server

ü   Teradata

ü   DB2 for i, DB2 LUW, and DB2 z/OS

ü   Informix

ü   Sybase Adaptive Server Enterprise (ASE)

ü   MySQL

 

l   Oracle GoldenGate Veridata doesn't support the following databases for repair functionality, but supported by Oracle GoldenGate:

ü   Non Stop (Enscribe, SQL/MP, SQL/MX)

BigData Hive

l   最新版本Oracle GoldenGate Veridata (12.2.1.4.0) 9月版本（20201029）

l   12.2.1.4.0為基礎版本。

l   12.2.1.4.0各個更新新特性：

（1）9月版本：

ü   This is a compatibility release for bug fix only, no new feature was added.

（2）7月版本：

ü   Support has been added for MySQL Repair Functionality

ü   Oracle GoldenGate Veridata now supports users to repair out-of-sync data in MySQL database.

 

（3）1月版本：

ü   Oracle GoldenGate Veridata 12.2.1.4.200115 release includes the following new and changed features :

ü   Added MySQL support for comparison as source or target database. However, there is no support added for repair.

ü   Oracle GoldenGate Veridata now fully supports Oracle Multitenant Container database.

ü   Added support to EXCLUDE VIEWS when creating compare pair.

ü   Added support to filter objects using NOT LIKE when creating compare pair.

l   OGG Veridata Server不需要一定在服務端安裝OGG軟體，如果安裝在有OGG軟體的伺服器上，則需要安裝在不同目錄。

Oracle Fusion Middleware Supported System Configurations

地址：

Oracle Fusion Middleware System Requirements and Specifications

地址：

l   如果為全新安裝，不存在Oracle Fushion Middleware Infrastructure與Veridata Server軟體不同版本，則可以不進行驗證，安裝統一版本即可。

Oracle Fusion Middleware Understanding Interoperability and Compatibility

地址：

本章節主要描述Oracle Fushion Middleware Infrastructure安裝，安裝OGG Veridata Server需要先在作業系統安裝Oracle Fushion Middleware Infrastructure，然後才可以將OGG Veridata Server安裝在Oracle Fushion Middleware Infrastructure相同Oracle_Home。

l   UNIX作業系統，Oracle建議umask設定為027。

l   需要與安裝程式同一終端執行上述命令。

 

$ umask 027

UNIX作業系統，不能使用root安裝程式。

當管理軟體時，例如打補丁，需要使用與安裝相同使用者。

Windows，執行安裝，需要具有Administrator許可權。

下面連結檢視需要安裝的版本jdk：

ORACLE建議jdk目錄安裝在：/home/oracle/products/jdk

For 12c (12.2.1.4.0), the certified JDK is 1.8.0_221 and later

JDK下載：

完成作業系統JDK安裝之後，使用Oracle Fusion Middleware 12.2.1.4.0 Infrastructure installer安裝Oracle WebLogic Server 12.2.1.4.0

以及Oracle Java Required Files (JRF) Infrastructure services

 

Oracle home需要考慮如下：

a) 路徑不能包含空格。

b) 在每個Oracle home目錄只能安裝一個Oracle Fusion Middleware product例項。

c) 如果要在一臺機器維護多版本，不同版本需要具有不同Oracle home目錄。

l   可以參考下面文件，檢視更詳細相關資訊：

l   Oracle GoldenGate Veridata服務端需要一個資料庫作為資料檔案庫，用來儲存使用Oracle GoldenGate Veridata網頁端時建立的物件的資訊以及環境首選項配置等。

l   Use the Repository Creation Utility (RCU) to create the repository. See Creating the Oracle GoldenGate Veridata Repository Schema.

l   Oracle

l   SQL Server

l   Oracle

a) Create a user and password.

b) Specify QUOTA UNLIMITED on the user's default tablespace.

l   SQL Server

a) Create a database and login that is a user of the database where you will be installing the repository.

b) Grant this login sufficient privileges to perform the following operations:

c) CONNECT to the database

d) CREATE, ALTER, DROP TABLE in the database

e) CREATE and DROP INDEX in the database

f) INSERT, UPDATE, DELETE from tables in the database

h) SELECT from tables in the database

i) ALTER SCHEMA of the login's default schema

l   Oracle

a) The database instance name

b) The ORACLE_HOME (if using TNSNAMES connection method)

c) Default and temporary tablespaces for the repository (if you will be creating a new user for the server component during installation)

d) A login and password, if using an existing database user for the repository.

l   SQL Server

a) The SQL Server instance must be configured to use a static port number.

b) This port is stored in a configuration file so that it can be referenced to make JDBC connections to the database.

c) A login and password (or integrated authentication), if using an existing database user for the repository.

這個章節主要描述OGG Veridata Server端安裝，安裝OGG Veridata Server，需要先安裝ADR（Application Development Runtime）環境Oracle Fushion Middleware Infrastructure。

One installer program installs both Oracle GoldenGate Veridata Web Server component and Oracle GoldenGate Veridata Web User Interface.

JDK 1.8.0_221 or higher is required for the Veridata Web User Interface installation.

l   Microsoft Internet Explorer version 11 or higher

l   Mozilla Firefox version 38 or higher

l   Google Chrome version 43

Minimum of 1024 x 768

l   The Oracle GoldenGate Veridata Web application interacts with Oracle WebLogic Server.

l   Oracle WebLogic Server is installed with Oracle GoldenGate Veridata Server on default ports. You can change the port numbers if needed.

l   Oracle GoldenGate Veridata Web makes use of the default port 8830.

l   Java agent除了NonStop平臺都可以使用，NonStop platform只能使用C-agent

l   Java agent使用UTF-8字符集比較字元資料。Out-of-sync資料使用UTF-8字符集寫入報告檔案。

l   OGG Veridata Oracle C-Agent可以用於比較源端與目標端相同字符集以及相同位元組序的平臺。

l   C-Agent不能與Java-agent進行比較，比較報告中非有效utf-8字元將以16進位制顯示。

l   一個agent不能檢索不同資料庫例項資料行。

l   Java agent使用JDBC連線資料庫， 可以安裝在資料庫所在伺服器或者不同伺服器，但是安裝在不同資料庫要考慮不在資料庫伺服器帶來的網路頻寬消耗以及處理資源消耗。

注：Java agent可以不安裝在要比對的資料庫端，可以遠端連線，也可以安裝在OGG Veridata Server端，然後一次安裝啟動多個agent，連線不同資料庫。

Oracle GoldenGate Veridata provides a Java-based agent for the following databases:

l   DB2 for i, DB2 LUW, and DB2 z/OS

l   Oracle

l   SQL Server

l   Sybase ASE

l   Teradata

l   Informix

l   BigData Hive

l   C-agent對於NonStop SQL/MP以及Enscribe資料庫是必須的，可以安裝在守護環境。

l   C-agent支援Oracle database，但是從11.2.1.0.0版本開始，不再被加強。

l   C-agent必須安裝在資料庫所在伺服器。

l   對於Oracle，C-agent動態函式庫要可用，在不同平臺需要設定如下環境變數：

Variable                          Operating System

PATH=Oracle_libraries               Windows

SHLIB_PATH=Oracle_libraries         HP-UX

LIBPATH=Oracle_libraries            IBM AIX

LD_LIBRARY_PATH=Oracle_libraries    All other supported UNIX platforms

l   agent需要至少1GB記憶體

l   agent對於磁碟需求根據不同平臺需要不同，大約200M。

    Agent元件需要的許可權並不需要預先配置，只需要在訪問OGG Veridata Server網頁端時，配置連線串，連線資料庫使用者時，該使用者需要具有相應許可權，才能正常比對與repair修復資料。

l   Required database privileges for Oracle GoldenGate Veridata Agent

ü   DB2

SELECT privileges on the tables that will be compared.

ü   Oracle

GRANT CONNECT

GRANT SELECT on the tables to be compared. It is recommended, but not necessary, to GRANT SELECT ANY TABLE.

SELECT_CATALOG_ROLE

ü   NonStop SQL/MP and Enscribe

Read access to the SQL/MP system catalog (for queries to CATALOGS table).

Read access to the SQL/MP catalogs that you want Oracle GoldenGate Veridata to use.

Read access to the DDL dictionaries that you want Oracle GoldenGate Veridata to use.

Read access to the Enscribe and SQL/MP tables that will be compared.

Read, write, create, purge permissions for the Oracle GoldenGate Veridata report and trace files, and access to the sub volumes where they are installed.

ü   SQL Server

db_datareader or the equivalent on the tables to be compared.

VIEW DEFINITION in the databases to be compared.

The database must allow SQL Server authentication.

ü   Sybase ASE

Access to the databases to be compared.

SELECT privileges on the tables to be compared.

SELECT privileges on the sysdatabases system table in the master database to view the list of databases available in the server.

ü   Teradata

SELECT privileges on the tables to be compared.

ü   Informix

SELECT privileges on the tables to be compared.

ü   BigData Hive

SELECT privileges on the tables to be compared.

 

l   Required Database Privileges for Using the Repair Feature

ü   For all databases, the database user must have the UPDATE, INSERT, and DELETE privileges on the tables to be repaired.

ü   For Sybase database, if the table has triggers and suppression of triggers enabled, the database user must have the replication_role privilege.

ü   For SQL Server database, If the table being repaired has 'identity columns',

the Repair User specified must be either the table owner, or should have ALTER permission on the table that is being repaired.

# uname -a

# java -version

# java 不符合下載jdk，安裝。

# rpm -ivh jdk-8u261-linux-x64.rpm

# su - oracle

$ vi .bash_profile

export JAVA_HOME=/usr/java/jdk1.8.0_261-amd64

export PATH=$PATH:/usr/java/jdk1.8.0_261-amd64/bin

# 建立Oracle_Home，如果不建立預設安裝/home/oracle/Oracle/Middleware/Oracle_Home

# mkdir -p /u01/app/Oracle/Middleware/Oracle_Home

# chown -R oracle:oinstall /u01/app/Oracle

3.2 安裝Fusion Middleware Infrastructure

Application Development Runtime

https://www.oracle.com/middleware/technologies/weblogic-server-installers-downloads.html

找到對應版本選項下載，

Fusion Middleware Infrastructure Installer。

$ /usr/java/jdk-15/bin/java -jar fmw_12.2.1.4.0_infrastructure.jar

 

 

 

java版本安裝為jdk 261

 

 

 

 

 

$ export DISPLAY=192.168.204.100:0.0

$ /usr/java/jdk-15/bin/java -jar fmw_12.2.1.4.0_ogg.jar

# 選擇Oracle Home時需要選則Fushion Middleware Infrastructure安裝時的Oracle Home。

 

 

Oracle Home 要選擇，上一步Oracle Fushion Middleware Infrastructure安裝的Oracle Home目錄。

 

$ /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch lsinventory -jre $ORACLE_HOME/oracle_common/jdk/jre

參考README，如果必要升級opatch

$ echo $ORACLE_HOME

/home/oracle/Oracle/Middleware/Oracle_Home

$ cd oggveridata/31044508/

$ /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch apply

Oracle Interim Patch Installer version 13.9.4.2.1

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

 

Oracle Home       : /home/oracle/Oracle/Middleware/Oracle_Home

Central Inventory : /oracle/app/oraInventory

   from           : /home/oracle/Oracle/Middleware/Oracle_Home/oraInst.loc

OPatch version    : 13.9.4.2.1

OUI version       : 13.9.4.0.0

Log file location : /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2020-10-20_23-44-36PM_1.log

 

OPatch detects the Middleware Home as "/home/oracle/Oracle/Middleware/Oracle_Home"

 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   31044508 

 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

 

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/home/oracle/Oracle/Middleware/Oracle_Home')

 

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '31044508' to OH '/home/oracle/Oracle/Middleware/Oracle_Home'

 

Patching component oracle.rcu.veridata, 12.2.1.4.0...

 

Patching component oracle.veridata.agent.core, 12.2.1.4.0...

 

Patching component oracle.veridata.agent.core, 12.2.1.4.0...

 

Patching component oracle.veridata.web.core, 12.2.1.4.0...

 

Patching component oracle.veridata.web.core, 12.2.1.4.0...

 

Patching component oracle.fmw.upgrade.veridata, 12.2.1.4.0...

Patch 31044508 successfully applied.

Log file location: /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2020-10-20_23-44-36PM_1.log

 

OPatch succeeded.

SYS@messay > create user oggveridata identified by oggveridata;

SYS@messay > grant unlimited tablespace to oggveridata;

進入$ORACLE_HOME/oracle_common/bin啟動RCU.

l   Set the JAVA_HOME environment variable to your JDK location.

l   On UNIX operating systems:

setenv JAVA_HOME=/home/Oracle/Java/jdkversion

l   On Windows operating systems,

右鍵計算機-屬性-高階計算機設定配置環境變數

 

l   進入ORACLE_HOME/oracle_common/bin目錄

Repository Creation Utility RCU.

a) On UNIX operating systems:

$ export DISPLAY=192.168.204.100:0.0

$ ./rcu

l   如果執行RCU時，擁有的資料庫使用者沒有DBA許可權，則需要在選擇功能時，只選擇Perform Product Load，最後完成介面找到指令碼目錄，交由DBA許可權使用者執行下面指令碼，建立相應表空間，完成system load：

SYS@messay > @script_systemLoad.sql

# 根據上面指令碼提示，需要為每個schema設定密碼，記住密碼，下一步再次執行rcu還需要使用。

 

l   如果具有DBA許可權，則選擇，systemload and product load。

Unix：

$ export DISPLAY=192.168.204.100:0.0

$ ./rcu

# 選擇

On Windows operating systems:

rcu.bat

 

 

RCU建立Repository

如果安裝沒有DBA許可權，則需要選擇第二個，生成SQL指令碼，由具有DBA許可權的使用者執行，這裡選擇第二個，需要手工使用DBA使用者執行system_load指令碼之後再次執行RCU。

 

 

 

進入上面Script Location目錄，執行script_systemLoad.sql指令碼

再次執行RCU

密碼：Oracle123

 

3.6 建立Weblogic Domain

    OGG Veridata Server透過Weblogic域進行管理，所以在可以訪問OGG Veridata Server Web Interface之前，需要建立Weblogic Domain。

進入ORACLE_HOME/oracle_common/common/bin目錄：

On UNIX operating systems:

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin

$ ./config.sh

 

On Windows operating systems:

config.cmd

l   Task 1, "Selecting the Domain Type and Domain Home Location"

l   Task 2, "Selecting the Configuration Templates"

l   Task 3, "Configuring the Administrator Account"

l   Task 4, "Specifying the Domain Mode and JDK"

l   Task 5, "Specifying the Datasource Configuration Type"

l   Task 6, "Specifying JDBC Component Schema Information"

l   Task 7, "Testing the JDBC Connections"

l   Task 8, "Specifying Keystore Details"

l   Task 9, "Selecting Advanced Configuration"

l   Task 10, "Configuring the Administration Server Listen Address"

l   Task 12, "Configuring Managed Servers"

l   Task 13, "Reviewing Your Configuration Specifications and Configuring the Domain"

l   Task 14, "Reviewing Your Domain Home and Administration Server URL"

 

ORACLE_HOME/oracle_common/common/bin/config.sh建立domain

選擇Veridata Standard Weblogic Server Domain，會自動選中下面兩個。

 

 

輸入管理員帳戶密碼，密碼輸入Oracle123

 

 

 

輸入相關連線資訊，電子Get RCU Configuration檢視是否成功。

如果上面資訊正確，則下面會自動檢索正確，如果不正確，選中行，修改資訊即可。

 

 

 

 

 

 

 

cd DOMAIN_HOME/bin目錄：

 

On UNIX operating systems, run:

./startWebLogic.sh

# config.sh 時建立的管理員賬號。

Enter username to boot WebLogic server:weblogic

Enter password to boot WebLogic server:Oracle123

# 絕對路徑

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin

$ /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin/startWebLogic.sh

l   將管理員賬號密碼寫入檔案

l   明文寫入檔案之後，啟動一次之後，Oracle會將密碼使用者使用AES256加密。

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/servers/AdminServer

$ mkdir security

$ cd security

$ vi boot.properties

username=weblogic

password=Oracle123

# 啟動命令

$ nohup /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin/startWebLogic.sh >nohup.out 2>&1 &

 

On Windows operating systems, run:

startWebLogic.cmd

訪問地址：

http://192.168.204.231:7001/console

# 可以透過上面地址管理Veridata Server登陸帳戶密碼，許可權等等，管理域等。

3.7.4 停止weblogic

$ /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/bin/stopWeblogic.sh

$ /home/oracle/Oracle/Middleware/Oracle_Home/veridata/bin

$ ./veridataServer.sh start VERIDATA_server1 t3://192.168.204.231:7001

注：啟動 VERIDATA_server1 為在 weblogic 管理伺服器中建立的域 server 名稱，預設即為 VERIDATA_server1 ， t3://192.168.204.231:7001 預設即為該地址，所以啟動如果未自定義埠地址， server 名稱，可以不指定。

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/servers/VERIDATA_server1

$ mkdir security

$ cd security

$ vi boot.properties

username=weblogic

password=Oracle123

# 後臺啟動

$ nohup /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/veridata/bin/veridataServer.sh start VERIDATA_server1 t3://192.168.204.231:7001 &

http://192.168.204.231:8830/veridat a

# 登陸使用者可以使用weblogic管理員，也可以在http://192.168.204.231:7001/console管理頁面-安全領域-使用者與組建立veridata許可權使用者。

$ /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/veridata/bin/veridataServer.sh stop

 

OGG Veridata目錄結構：

Directory Variable                 Directory Path

 

ORACLE_HOME                       /install_location/Oracle_Home.

                                This is the home directory for the Oracle                               Fusion Middleware products.

 

VERIDATA_PRODUCT_HOME            /ORACLE_HOME/veridata

 

AGENT_ORACLE_HOME                 /VERIDATA_PRODUCT_HOME/agent

 

AGENT_DEPLOY_LOCATION            This is the location where the Oracle                                   GoldenGate Veridata Agent is deployed.

# Note that this location should be outside the ORACLE_HOME.

l   如果agent部署在OGG Veridata Server，則跳過此安裝步驟。

$ java -jar fmw_12.2.1.4.0_infrastructure.jar

安裝配置圖形，參考3.2章節

$ java -jar fmw_12.2.1.4.0_ogg.jar

 

$ unzip p31044508_122140_Generic_20200717_OGG_veridata_bundlepatch.zip

$ export ORACLE_HOME=/veridata/Oracle/Middleware/Oracle_Home

# 校驗補丁版本，opatch版本

$ /veridata/Oracle/Middleware/Oracle_Home/OPatch/opatch lsinventory -jre $ORACLE_HOME/oracle_common/jdk/jre

$ /veridata/Oracle/Middleware/Oracle_Home/OPatch/opatch apply

安裝agent軟體之後，需要使用下面命令生成agent location相關目錄以及啟動指令碼、配置樣例檔案等：

agent_config.sh|.bat AGENT_DEPLOY_LOCATION

$ cd /veridata/Oracle/Middleware/Oracle_Home/veridata/agent

$ ./agent_config.sh /veridata/Oracle/Middleware/agent_location

Successfully deployed the agent.

# /veridata/Oracle/Middleware/agent_location 必須在 /veridata/Oracle/Middleware/Oracle_Home 之外。

# cd進入agent部署目錄AGENT_DEPLOY_LOCATION.

$ cd /veridata/Oracle/Middleware/agent_location

$ cp agent.properties.sample agent.properties

$ vi agent.properties

server.port=7862

database.url=jdbc:oracle:thin:@192.168.204.181:1521:honor  

# 這種寫法是指定例項 sid 寫法，如果要指定 service_name 需要另外寫法

server.jdbcDriver=ojdbc8.jar oracle.xdb.jar

# 將drivers檔案複製到AGENT_DEPLOY_LOCATION/drivers目錄。

$ cd /veridata/Oracle/Middleware/agent_location/drivers

$ cp /veridata/Oracle/Middleware/Oracle_Home/veridata/agent/drivers/ojdbc8.jar .

cd進入agent部署目錄AGENT_DEPLOY_LOCATION.

$ ./agent.sh start agent.properties

# agent.properties檔案為上面包含連線資料庫資訊的配置檔案。

 

# 停止agent

$ ./agent.sh stop

訪問： http://192.168.204.231:8830/veridata

使用 http://192.168.204.231:7001/console地址新增的使用者登陸veridata。

 

 

 

 

進行比對大致步驟為（以下步驟在OGG Veridata Server Web Interface中均有功能模組對應）：

ü   配置連線配置。

ü   配置對比組。

ü   對比組中建立對比表對，如果組未建立表對，則後續job也無法在組中檢索到比對錶對，所以需要為組建立比對錶對。

ü   建立比對job，可以單獨建立job或者使用上一步建立的比對組，如果建立job未關聯比對組，則執行job是依然需要再次選擇group，然後檢索group中比對錶對，進行對比。

ü   執行job，選擇要比對的表對進行run。

ü   在finished裡可以看到比對結果，以及可以執行repair，進行repair需要連線配置資料庫使用者具有相應許可權。

ü   注意Source與Target選擇，如果使用Veridata進行repair，則需要嚴格選擇，因為會以Source作為基準進行資料修復，Target多餘的資料會delete，不同的資料會update，不存在的會insert。

ü   在組配置中點選上圖Go to Compare Pair Configuration配置比對對，即Source與Target表對應對。