[cx-oracle-users] How to sync two oracle databases (schemas)

[M.M.Rashid (Rubel) <mm...@gm...>]

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-...@li...> wrote:

> Send cx-oracle-users mailing list submissions to
>         cx-...@li...
>
> 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-...@li...
>
> You can reach the person managing the list at
>         cx-...@li...
>
> 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)" <mm...@gm...>
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] cx-oracle-users Digest, Vol 142, Issue
>         1
> Message-ID:
>         <CABs5CDFw5Z_6f2TpH2vkf8qStv+0AF=f=
> vPc...@ma...>
> 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-...@li...> wrote:
>
> > Send cx-oracle-users mailing list submissions to
> >         cx-...@li...
> >
> > 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-...@li...
> >
> > You can reach the person managing the list at
> >         cx-...@li...
> >
> > 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 <ant...@gm...>
> > To: cx-...@li..., DB...@py...,
> >         pyt...@py...
> > Subject: [cx-oracle-users] cx_Oracle 7.3
> > Message-ID:
> >         <
> > CAE...@ma...>
> > 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-...@li...
> > 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: mm...@gm...
> Phone: +61 406996028 (Mobile)
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> 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: mm...@gm...
Phone: +61 406996028 (Mobile)