sql ser numdi ora ki query- help

[Mr Mirchi]

evaranna sql server numdi oracle ki openquery (linkedserver) use chesaraaaaa

 

openquery tho update chesthunte oracle lo records ni...time thisukuntumdhi and row lock avuthumdhi vayaaa

 

evariki ide lekapothe dhandaalu

[BostonBullodu]

4 minutes ago, Mr Mirchi said:

evaranna sql server numdi oracle ki openquery (linkedserver) use chesaraaaaa

 

openquery tho update chesthunte oracle lo records ni...time thisukuntumdhi and row lock avuthumdhi vayaaa

 

evariki ide lekapothe dhandaalu

sql server to oracle ETL use chesi oracle loki load ayyaka update chesuko kadaaa 

[Mr Mirchi]

3 hours ago, BostonBullodu said:

sql server to oracle ETL use chesi oracle loki load ayyaka update chesuko kadaaa 

ETL lo job create chesi oracle numdi every 2 mins ki data sql server lo dump cheyatamaaa,, 

 

basic ga oracle lo student data ni sql server tables ki ivvaali for every 3mins or so...orace lo vunna 2-3 tables lo data ni 2-3 different tables lo dump cheyali data

[AFDBphilosopher]

38 minutes ago, Mr Mirchi said:

ETL lo job create chesi oracle numdi every 2 mins ki data sql server lo dump cheyatamaaa,, 

 

basic ga oracle lo student data ni sql server tables ki ivvaali for every 3mins or so...orace lo vunna 2-3 tables lo data ni 2-3 different tables lo dump cheyali data

Straight away ETl cheyyochu kadha?

Or advanced ga change data capture cheyyochu

Adhi advanced topic

Azure data factory ani okati untundi..Adhi use cheyyi, okavela option untey