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!

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
1 comment
164 views