Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ ogg Oracle to SQL Server 2005 to achieve synchronization     - Java memory model subclasses (Programming)

- Ubuntu 14.04 + xRDP + Xfce implement Windows Remote Desktop Connection (Linux)

- C language to view various types of data size (Programming)

- Zend Studio PHP syntax color scheme to export (Linux)

- Simple security measures to reinforce the Linux kernel (Linux)

- In-depth understanding of capture Node.js garbage collection and memory leaks (Programming)

- Fedora 20 Installation and Configuration (Linux)

- Linux System Getting Started Learning: The Linux anacron command (Linux)

- PostgreSQL with the C Completing the storage process instances (Database)

- Linux SSH remote connection service slow Solutions (Linux)

- CentOS 6.5 three ways to configure the IP address (Linux)

- Lazarus IDE Start Basics Tutorial (Linux)

- GROUP BY extension (Database)

- Puppet Detailed centralized configuration management system (Server)

- Linux server disk expansion and Oracle tablespace file migration operations (Database)

- OpenResty load balancing MySQL (Database)

- Linux systems for entry-learning: Install closed-source packages in Debian (Linux)

- File compression and packaging commands under Linux (Linux)

- Linux System Getting Started Learning: rename multiple files in Linux (Linux)

- RHEL7 unattended automatic installation DHCP + TFTP + SYSLINUX + TFTP + Kickstart (Linux)

  ogg Oracle to SQL Server 2005 to achieve synchronization
  Add Date : 2018-11-21      
  First, the source (Oracle) Configuration
1. Create a synchronization test table
  create table gg_user.t01 (name varchar (20) primary key);
  create table gg_user.t02 (id int primary key, name varchar (20));
  2. Add the definition file (heterogeneous transmission is between the need to convert the field type of processing required to generate defgen tool definition files)
    GGSCI (kermart) 4> edit params defgen
    defsfile D: \ ggate \ dirdef \ t01.def
    userid gg_user, password oracle
    table gg_user.t01;
    table gg_user.t02;
 NOTE: If you have more than one table, the needs of each are listed, if the user needs all the tables are synchronized, directly on the table gg_user *;.
    If not listed, the replication process starts will be reported the following error:
    ERROR OGG-00423 Oracle GoldenGate Delivery for SQL Server, RPL01.prm: Could not find definition for GG_USER.T02.
    ERROR OGG-01668 Oracle GoldenGate Delivery for SQL Server, RPL01.prm: PROCESS ABENDING.
    Build definition file
D: \ ggate> defgen.exe paramfile D: \ ggate \ dirprm \ defgen.prm

************************************************** *********************
        Oracle GoldenGate Table Definition Generator for Oracle
      Version OGGCORE_11.
      Windows x64 (optimized), Oracle 11g on Apr 23 2012 05:48:41

Copyright (C) 1995, 2012, Oracle and / or its affiliates. All rights reserved.

                    Starting at 2014-04-24 16:43:37
************************************************** *********************

Operating System Version:
Microsoft Windows 7, on x64
Version 6.1 (Build 7601: Service Pack 1)

Process id: 6828

************************************************** *********************
** Running with the following parameters **
************************************************** *********************
defsfile D: \ ggate \ dirdef \ t01.def
userid gg_user, password ******
table gg_user.t;
Retrieving definition for GG_USER.T


Definitions generated for 1 table in D: \ ggate \ dirdef \ t01.def
T01.def will be copied to the directory sql server ogg dirdef under.
3. Add supplemental logging
GGSCI (kermart) 7> dblogin userid gg_user, password oracle
GGSCI (kermart) 8> add trandata gg_user.t01
GGSCI (kermart) 8> add trandata gg_user.t02

4. Add the extraction process
GGSCI (kermart) 5> edit params ext01
extract ext01
userid gg_user, password oracle
exttrail D: \ ggate \ dirdat \ et
TABLE gg_user.t01;
TABLE gg_user.t02;

GGSCI (kermart) 1> add extract ext01, tranlog, begin now
GGSCI (kermart) 2> add exttrail D: \ ggate \ dirdat \ et, extract ext01

5. Add the delivery process
GGSCI (kermart) 6> edit params pump01
extract pump01
userid gg_user, password oracle
rmthost, mgrport 7810
rmttrail E: \ ggate \ dirdat \ rt
TABLE gg_user.t01;
TABLE gg_user.t02;

GGSCI (kermart) 5> add extract pump01, exttrailsource D: \ ggate \ dirdat \ et, begin now
GGSCI (kermart) 6> add rmttrail E: \ ggate \ dirdat \ rt, extract pump01

Second, the target side (sql server) configuration
1. Configuring ODBC Data Sources
    Control Panel - Administrative Tools - Data Sources (ODBC), add the system DNS, named test01, pay attention to choose the type of driver for the SQL Server Native Client 10.0
    2. Create a test table (structure consistent with the source)
    create table hjj.t01 (name varchar (20) primary key);
  create table hjj.t02 (id int primary key, name varchar (20));
  3. Add checkpointtable
  GGSCI (kermart) 10> edit param ./globals
checkpointtable hjj.ckp
GGSCI (kermart) 8> dblogin sourcedb t01 userid sa password sa
GGSCI (kermart) 9> add checkpointtable hjj.ckp
  3. Add the replication process
  GGSCI (kermart) 58> edit param rpl01
  replicat rpl01
  sourcedefs E: \ ggate \ dirdef \ t01.def
  targetdb t01 userid sa, password sa
  reperror default, discard
  discardfile E: \ ggate \ dirrpt \ rpl.dsc append
  MAP gg_user.t01, TARGET hjj.t01;
  MAP gg_user.t02, TARGET hjj.t02;

  GGSCI (kermart) 12> add replicat rpl01, exttrail E: \ ggate \ dirdat \ rt, begin now, checkpointtable hjj.ckp

  Third, the test
  1. Start the process
  start ext01
  start pump01
  GGSCI (kermart) 9> info all

Program Status Group Lag at Chkpt Time Since Chkpt

EXTRACT STOPPED EXDP 00:00:00 16:40:29
EXTRACT STOPPED EXORA 00:00:00 16:40:32
EXTRACT RUNNING EXT01 00:00:00 00:00:09
EXTRACT STOPPED EXT1 00:00:00 162: 50: 03
EXTRACT RUNNING PUMP01 00:00:00 00:00:05
EXTRACT STOPPED PUMP1 00:00:00 162: 49: 59
REPLICAT STOPPED MSREP 00:00:00 187: 22: 15
REPLICAT STOPPED REP1 00:00:00 163: 47: 29
 start rpl01
 GGSCI (kermart) 59> info all

Program Status Group Lag at Chkpt Time Since Chkpt

EXTRACT STOPPED EXT1 00:00:00 163: 48: 28
EXTRACT STOPPED MSEXT 00:00:00 187: 23: 13
EXTRACT STOPPED PUMP1 00:00:00 163: 48: 25
REPLICAT STOPPED REP1 00:00:00 162: 49: 46
REPLICAT RUNNING RPL01 00:00:00 00:00:04
2. On the source side (oracle) DML operations
 SQL> insert into t01 select 'lyn' || rownum from dual connect by level <= 100;

100 lines have been created.

SQL> commit;

Submit completed.

SQL> insert into t02 select rownum, 'moon' || rownum from dual connect by level <= 100;

100 lines have been created.

SQL> commit;

Submit completed.

SQL> select count (*) from t01;

  COUNT (*)

SQL> select count (*) from t02;

  COUNT (*)
3. Check the target side (sql server) synchronous data replication
C: \> sqlcmd -S kermart -U sa -P sa -d TEST
1> select count (*) from hjj.t01;
2> go


(1 row affected)
1> select count (*) from hjj.t02
2> go


(1 row affected)
- CentOS 6.5 installation configuration DRBD (Server)
- CentOS6.0 successful installation and configuration OpenCV (Linux)
- Oriented C ++ test-driven development (Programming)
- DupeGuru- find and remove duplicate files (Linux)
- Help you make Git Bisect (Linux)
- Using shell users or virtual users to login to pureftpd (Linux)
- Linux Telnet access Windows 7 configuration procedure (Linux)
- To use Java arrays implement the order form (Programming)
- Oracle bdump file soaring (Database)
- Linux system security (Linux)
- Advanced permissions Linux file system settings (Linux)
- CentOS install Redis (Database)
- Hive start being given: Found class jline.Terminal, but interface was expected (Database)
- Specifies the open ports of the SUSE firewall settings (Linux)
- Sudo and Root Account in Ubuntu related (Linux)
- GRUB and Linux system repair (Linux)
- Linux upgrade GCC 4.8.1 clear and concise tutorials (Ubuntu 12.04 64-bit version as an example) (Linux)
- How to use the on-screen keyboard in Linux (Linux)
- Integrated security administrator Linux accident management (Linux)
- 10 practical Java programming technology (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.