Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bi-Directional Replication (Oracle and SQL Server) by OGG 21.15

JhilDec 18 2024

Dear Experts ,

We are implementing Bi-Directional replication between Oracle and MS-SQL Server.

And tables are not identical between Oracle and SQL Server.

52 columns for Oracle Table

35 columns for SQL Server Tables.

>> Column mapping details :
============================
document_path=document_path,
start_date=emi_start_month,             >>>>>>>>>>>>>> different column name mapping
request_type_id=loan_advance_type_id,   >>>>>>>>>>>>>>  different column name mapping             
sanction_user_term_type=sanction_user_term_type,

Environment Details

====================

Oracle Version is 19.22 on RHEL 8

MS-SQL Version is : SQL Server 2019 on Windows 2022

GG Version is 21.15

Need some clarity

If GG version is 21.15, can we use TRANLOGOPTIONS EXCLUDEUSER <GG_USER>  for Extract param file  ?  (or) Do we need to use only SETTAG & EXCLUDETAG in param files?
Can we use AUTO CDR between Oracle and SQL Server , if we use 21.15 GG Version? 

Thanks in Advance,

Jhil

Comments
Post Details
Added on Dec 18 2024
0 comments
36 views