Yes, that's the tool i am talking about oh okay, so ideally if i pass my two connections, it will get me a difference at the whole DB level and from the result, i can segregate what i need? Sorry if i sound ignorant, i am totally new to SQLAlchemy.
Thanks, Neethu On Tuesday, May 22, 2018 at 4:33:34 PM UTC+5:30, Neethu Abhinav wrote: > > Hi, > > I have installed sqlalchemy 1.2.7, and went through the docs for > sqlAlchemy Diff, but i am still confused on how to use it effectively for > my requirement. > > *We use Oracle 12C* > > 1. We have two databases, which have the schema in common, DB1 Schema A, > DB2 Schema A > 2. I want to compare these two schemas across db's to get the difference > in the metadata.(eg: difference in Table columns, missing index and so on). > 3. Are these possible? > 4. And in the documentation, it is mentioned to use compare(uri_left, > uri_right), what are these uri's and how to use them or rather create them. > Please guide me through this. > > Thanks, > Neethu > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.