How to sync two oracle databases (schemas)
"M.M.Rashid (Rubel)" <[email protected]> Tue, 11 Feb 2020 10:02:27 +0800
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CABs5CDFYjYCPfv=wi269MWZ2G85cY-tja_cxQOxTWGaft-KuCw@mail.gmail.com> |
--===============4766017997103997399== Content-Type: multipart/alternative; boundary="0000000000008ee561059e4341eb" --0000000000008ee561059e4341eb Content-Type: text/plain; charset="UTF-8" Hello Community, Need suggestion - need to sync two oracle databases/schemas. Any changes on source DB to be propagated to the target DB (INSERT/UPDATE/DELETE). Commercial tools out there in the market but is not an option. I was thinking of using oracle exp/imp and Python to automate. Any suggestion is appreciated. Source is on-prem and target is hosted on AWS. Thanks, Rubel On Mon, Feb 10, 2020 at 8:55 PM < cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote: > Send cx-oracle-users mailing list submissions to > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > or, via email, send a message with subject or body 'help' to > cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > You can reach the person managing the list at > cx-oracle-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of cx-oracle-users digest..." > > > Today's Topics: > > 1. Re: cx-oracle-users Digest, Vol 142, Issue 1 (M.M.Rashid (Rubel)) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 10 Feb 2020 16:25:58 +0800 > From: "M.M.Rashid (Rubel)" <[email protected]> > To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue > 1 > Message-ID: > <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=f= > [email protected]> > Content-Type: text/plain; charset="utf-8" > > Dear All, > > Looking for some case studies on syncing two oracle databases/schemas using > Python. There are commercial tools out in the market but we prefer to do > something using cx_Oracle , Python, exp/imp...etc > > Thanks in advance > > Regards, > Rashid > > On Tue, Dec 3, 2019 at 8:16 PM < > cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org> wrote: > > > Send cx-oracle-users mailing list submissions to > > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > or, via email, send a message with subject or body 'help' to > > cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > > > You can reach the person managing the list at > > cx-oracle-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of cx-oracle-users digest..." > > > > > > Today's Topics: > > > > 1. cx_Oracle 7.3 (Anthony Tuininga) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 2 Dec 2019 18:09:14 -0700 > > From: Anthony Tuininga <[email protected]> > > To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org, [email protected], > > [email protected] > > Subject: [cx-oracle-users] cx_Oracle 7.3 > > Message-ID: > > < > > CAE1XR-5eTEJziLJkHYSCh1yZ63QrP5iGQQHCogAvCjJ3Q+DfZw-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org> > > Content-Type: text/plain; charset="utf-8" > > > > What is cx_Oracle? > > > > cx_Oracle is a Python extension module that enables access to Oracle > > Database for Python 3.x and 2.x and conforms to the Python database API > 2.0 > > specifications with a number of enhancements. > > > > > > Where do I get it? > > https://oracle.github.io/python-cx_Oracle > > > > The easiest method to install/upgrade cx_Oracle is via pip as in > > > > python -m pip install cx_Oracle --upgrade > > > > > > What's new? > > > > See my colleague's blog post for an overview: > > > > > https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi > > > > See the full release notes for all of the details: > > > > > https://cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-2019 > > > > Please provide any feedback via GitHub issues ( > > https://github.com/oracle/python-cx_Oracle/issues). > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > cx-oracle-users mailing list > > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > > > > ------------------------------ > > > > End of cx-oracle-users Digest, Vol 142, Issue 1 > > *********************************************** > > > > > -- > M. M. RASHID(Rubel) > Perth, Australia. > E-mail: [email protected] > Phone: +61 406996028 (Mobile) > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > cx-oracle-users mailing list > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > > > ------------------------------ > > End of cx-oracle-users Digest, Vol 143, Issue 1 > *********************************************** > -- M. M. RASHID(Rubel) Perth, Australia. E-mail: [email protected] Phone: +61 406996028 (Mobile) --0000000000008ee561059e4341eb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div>Hello Community,</div><div><br></div><div>Need sugges= tion - need to sync two oracle databases/schemas. Any changes on source DB = to be propagated to the target DB (INSERT/UPDATE/DELETE). Commercial tools = out there in the market but is not an option. I was thinking of using oracl= e exp/imp and Python to automate. Any suggestion is appreciated. Source is = on-prem and target is hosted on AWS.<br></div><div><br></div><div>Thanks,</= div><div>Rubel</div><div><br></div><div><br></div><br><div class=3D"gmail_q= uote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Feb 10, 2020 at 8:55 PM= <<a href=3D"mailto:cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org">cx-or= acle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>> wrote:<br></div><blockquot= e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s= olid rgb(204,204,204);padding-left:1ex">Send cx-oracle-users mailing list s= ubmissions to<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:[email protected]= orge.net" target=3D"_blank">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <br> To subscribe or unsubscribe via the World Wide Web, visit<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"https://lists.sourceforge.net/lists/= listinfo/cx-oracle-users" rel=3D"noreferrer" target=3D"_blank">https://list= s.sourceforge.net/lists/listinfo/cx-oracle-users</a><br> or, via email, send a message with subject or body 'help' to<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:cx-oracle-users-request@lists= .sourceforge.net" target=3D"_blank">[email protected]= ge.net</a><br> <br> You can reach the person managing the list at<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:[email protected]= ourceforge.net" target=3D"_blank">cx-oracle-users-owner-5NWGOfrQmneRv+LV9MX5upmplPMkL2fr@public.gmane.org= et</a><br> <br> When replying, please edit your Subject line so it is more specific<br> than "Re: Contents of cx-oracle-users digest..."<br> <br> <br> Today's Topics:<br> <br> =C2=A0 =C2=A01. Re: cx-oracle-users Digest, Vol 142, Issue 1 (M.M.Rashid (R= ubel))<br> <br> <br> ----------------------------------------------------------------------<br> <br> Message: 1<br> Date: Mon, 10 Feb 2020 16:25:58 +0800<br> From: "M.M.Rashid (Rubel)" <<a href=3D"mailto:[email protected]= m" target=3D"_blank">[email protected]</a>><br> To: <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_bla= nk">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 1<br> Message-ID:<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=3Df=3D<a hr= ef=3D"mailto:vPc3KF1N8jXc%[email protected]" target=3D"_blank">vPc3KF1N= [email protected]</a>><br> Content-Type: text/plain; charset=3D"utf-8"<br> <br> Dear All,<br> <br> Looking for some case studies on syncing two oracle databases/schemas using= <br> Python. There are commercial tools out in the market but we prefer to do<br= > something using cx_Oracle , Python, exp/imp...etc<br> <br> Thanks in advance<br> <br> Regards,<br> Rashid<br> <br> On Tue, Dec 3, 2019 at 8:16 PM <<br> <a href=3D"mailto:cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"= _blank">cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>> wrote:<br> <br> > Send cx-oracle-users mailing list submissions to<br> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:cx-oracle-users@lis= ts.sourceforge.net" target=3D"_blank">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org= </a><br> ><br> > To subscribe or unsubscribe via the World Wide Web, visit<br> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"https://lists.sourceforge.= net/lists/listinfo/cx-oracle-users" rel=3D"noreferrer" target=3D"_blank">ht= tps://lists.sourceforge.net/lists/listinfo/cx-oracle-users</a><br> > or, via email, send a message with subject or body 'help' to<b= r> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:cx-oracle-users-req= [email protected]" target=3D"_blank">cx-oracle-users-request@lists= .sourceforge.net</a><br> ><br> > You can reach the person managing the list at<br> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:cx-oracle-users-own= [email protected]" target=3D"_blank">[email protected]= rceforge.net</a><br> ><br> > When replying, please edit your Subject line so it is more specific<br= > > than "Re: Contents of cx-oracle-users digest..."<br> ><br> ><br> > Today's Topics:<br> ><br> >=C2=A0 =C2=A0 1. cx_Oracle 7.3 (Anthony Tuininga)<br> ><br> ><br> > ----------------------------------------------------------------------= <br> ><br> > Message: 1<br> > Date: Mon, 2 Dec 2019 18:09:14 -0700<br> > From: Anthony Tuininga <<a href=3D"mailto:[email protected]= m" target=3D"_blank">[email protected]</a>><br> > To: <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D= "_blank">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>, <a href=3D"mailto:DB-SI= [email protected]" target=3D"_blank">[email protected]</a>,<br> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:python-announce@pyt= hon.org" target=3D"_blank">[email protected]</a><br> > Subject: [cx-oracle-users] cx_Oracle 7.3<br> > Message-ID:<br> >=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<<br> > <a href=3D"mailto:CAE1XR-5eTEJziLJkHYSCh1yZ63QrP5iGQQHCogAvCjJ3Q%2BDfZ= [email protected]" target=3D"_blank">CAE1XR-5eTEJziLJkHYSCh1yZ63QrP5iGQQHCog= [email protected]</a>><br> > Content-Type: text/plain; charset=3D"utf-8"<br> ><br> > What is cx_Oracle?<br> ><br> > cx_Oracle is a Python extension module that enables access to Oracle<b= r> > Database for Python 3.x and 2.x and conforms to the Python database AP= I 2.0<br> > specifications with a number of enhancements.<br> ><br> ><br> > Where do I get it?<br> > <a href=3D"https://oracle.github.io/python-cx_Oracle" rel=3D"noreferre= r" target=3D"_blank">https://oracle.github.io/python-cx_Oracle</a><br> ><br> > The easiest method to install/upgrade cx_Oracle is via pip as in<br> ><br> >=C2=A0 =C2=A0 =C2=A0python -m pip install cx_Oracle --upgrade<br> ><br> ><br> > What's new?<br> ><br> > See my colleague's blog post for an overview:<br> ><br> > <a href=3D"https://blogs.oracle.com/opal/python-cx_oracle-73-for-oracl= e-database-is-on-pypi" rel=3D"noreferrer" target=3D"_blank">https://blogs.o= racle.com/opal/python-cx_oracle-73-for-oracle-database-is-on-pypi</a><br> ><br> > See the full release notes for all of the details:<br> ><br> > <a href=3D"https://cx-oracle.readthedocs.io/en/latest/release_notes.ht= ml#version-7-3-december-2019" rel=3D"noreferrer" target=3D"_blank">https://= cx-oracle.readthedocs.io/en/latest/release_notes.html#version-7-3-december-= 2019</a><br> ><br> > Please provide any feedback via GitHub issues (<br> > <a href=3D"https://github.com/oracle/python-cx_Oracle/issues" rel=3D"n= oreferrer" target=3D"_blank">https://github.com/oracle/python-cx_Oracle/iss= ues</a>).<br> > -------------- next part --------------<br> > An HTML attachment was scrubbed...<br> ><br> > ------------------------------<br> ><br> ><br> ><br> > ------------------------------<br> ><br> > Subject: Digest Footer<br> ><br> > _______________________________________________<br> > cx-oracle-users mailing list<br> > <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_bl= ank">cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> > <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-user= s" rel=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists= /listinfo/cx-oracle-users</a><br> ><br> ><br> > ------------------------------<br> ><br> > End of cx-oracle-users Digest, Vol 142, Issue 1<br> > ***********************************************<br> ><br> <br> <br> -- <br> M. M. RASHID(Rubel)<br> Perth, Australia.<br> E-mail: <a href=3D"mailto:[email protected]" target=3D"_blank">mmrubel@gmai= l.com</a><br> Phone: +61 406996028 (Mobile)<br> -------------- next part --------------<br> An HTML attachment was scrubbed...<br> <br> ------------------------------<br> <br> <br> <br> ------------------------------<br> <br> Subject: Digest Footer<br> <br> _______________________________________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/list= info/cx-oracle-users</a><br> <br> <br> ------------------------------<br> <br> End of cx-oracle-users Digest, Vol 143, Issue 1<br> ***********************************************<br> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= class=3D"gmail_signature"><div dir=3D"ltr"><div>M. M. RASHID(Rubel)</div><= div>Perth, Australia.</div><div>E-mail: <a href=3D"mailto:[email protected]= " target=3D"_blank">[email protected]</a>=C2=A0 =C2=A0</div><div>Phone: +61= 406996028 (Mobile)</div></div></div></div> --0000000000008ee561059e4341eb-- --===============4766017997103997399== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============4766017997103997399== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users --===============4766017997103997399==--