Trying to use /setup GoldenGate 18c Microservice. I am new to GoldenGate architecture so excuse me if these questions are basic.
We can't use Standby because of different endian between source and target so looks like GoldenGate is only option.
Source is 11g ( 11.2.0.4) Solaris Sparc 64 Bit
Target is 18c ( Linux 64 bit)
Source DB Size : 90 TB
All schema from Source needs to replicated and there are lots of them
Question :
1. Source expdp and impdp on Target ( Only metadata). Question is about Triggers on Target side. Do Triggers/Constraints etc needs to be disabled on Target ? or there are some special option at the replicate/extract level setup. Anything else which needs to be taken care of.
2. Do I need to setup extract/replicate for all schema's individually or there is option to replicate everything ( other than sys/system stuff)
3. Question regarding Initial Load. I saw option for Initial Load in MicroService GUI. Can this be used to copy data from source to target ? Is there any limitation on data size ?
Thanks a lot.