Re: How to sync two oracle databases (schemas)
John Nielson <[email protected]> Mon, 10 Feb 2020 20:11:49 -0600
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAA444ZmirZ=um_qonW4-CMevpj=5NzbrLXiPKowvX7p0unyx8Q@mail.gmail.com> |
--===============4147494527859809111== Content-Type: multipart/alternative; boundary="000000000000953db5059e436183" --000000000000953db5059e436183 Content-Type: text/plain; charset="UTF-8" Triggers and two database links? On Mon, Feb 10, 2020 at 8:03 PM M.M.Rashid (Rubel) <[email protected]> wrote: > 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) > _______________________________________________ > cx-oracle-users mailing list > cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- John A. Nielson (504) 344.7225 --000000000000953db5059e436183 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div><div dir=3D"auto">Triggers and two database links?</div></div><div dir= =3D"auto"><br></div><div dir=3D"auto"><br></div><div><br><div class=3D"gmai= l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Feb 10, 2020 at 8:03= PM M.M.Rashid (Rubel) <<a href=3D"mailto:[email protected]">mmrubel@gma= il.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"m= argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"l= tr"><div>Hello Community,</div><div><br></div><div>Need suggestion - need t= o sync two oracle databases/schemas. Any changes on source DB to be propaga= ted 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 t= arget is hosted on AWS.<br></div><div><br></div><div>Thanks,</div><div>Rube= l</div><div><br></div><div><br></div><br><div class=3D"gmail_quote"><div di= r=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" target=3D"_blank"= >cx-oracle-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org</a>> wrote:<br></div><blo= ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left= :1px solid rgb(204,204,204);padding-left:1ex">Send cx-oracle-users mailing = list submissions 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> ***********************************************</blockquote></div></div><di= v dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" = style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa= dding-left:1ex"><br> </blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"= ><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">mmrube= [email protected]</a>=C2=A0 =C2=A0</div><div>Phone: +61 406996028 (Mobile)</div><= /div></div></div> _______________________________________________<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> </blockquote></div></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature" = data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><span style=3D"fon= t-family:arial,sans-serif">John A. Nielson</span><br></div>(504) 344.7225</= div></div> --000000000000953db5059e436183-- --===============4147494527859809111== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline --===============4147494527859809111== 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 --===============4147494527859809111==--