http://code.activestate.com/recipes/tags/schema-xml/2014-02-21T09:18:55-08:00ActiveState Code Recipes2014-02-21T09:18:55-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576534-dump-oracle-db-schema-to-text/

<p style="color: grey"> Python recipe 576534 by <a href="/recipes/users/186902/">Michal Niklas</a> (<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/oracle/">oracle</a>, <a href="/recipes/tags/schema/">schema</a>). Revision 19. </p> <p>Export Oracle schema to text. Usable to compare databases that should be the same</p> <p>Oracle schema info: <a href="http://www.eveandersson.com/writing/data-model-reverse-engineering" rel="nofollow">http://www.eveandersson.com/writing/data-model-reverse-engineering</a></p> <p>With <code>--separate-files</code> can save table information as <code>CREATE TABLE</code> statements and all view/function art objects are in separate files (sometime it is easier to compare directories with files than compare two big files)</p>

2014-02-21T09:16:15-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576621-dump-informix-schema-to-text/

<p style="color: grey"> Python recipe 576621 by <a href="/recipes/users/186902/">Michal Niklas</a> (<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/informix/">informix</a>, <a href="/recipes/tags/schema/">schema</a>). Revision 6. </p> <p>I needed "normalized" dump of Informix database so I can easily compare two databases. I have similar tools for other databases:</p> <p>PostgreSQL: <a href="http://code.activestate.com/recipes/576557/" rel="nofollow">http://code.activestate.com/recipes/576557/</a></p> <p>Oracle: <a href="http://code.activestate.com/recipes/576534/" rel="nofollow">http://code.activestate.com/recipes/576534/</a></p>

2014-02-21T09:17:23-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576557-dump-postgresql-db-schema-to-text/

<p style="color: grey"> Python recipe 576557 by <a href="/recipes/users/186902/">Michal Niklas</a> (<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/postgres/">postgres</a>, <a href="/recipes/tags/postgresql/">postgresql</a>, <a href="/recipes/tags/schema/">schema</a>). Revision 7. </p> <p>With PostgreSQL there is:</p> <pre class="prettyprint"><code>pg_dump --schema_only </code></pre> <p>but I wanted to compare my PostgreSQL and Oracle database schema dumped by: <a href="http://code.activestate.com/recipes/576534/">http://code.activestate.com/recipes/576534/</a></p>