http://code.activestate.com/recipes/tags/schema-postgres/2014-02-21T09:18:55-08:00ActiveState Code Recipes2013-03-28T10:24:55-07:00Mathias Loeschhttp://code.activestate.com/recipes/users/4185910/http://code.activestate.com/recipes/578503-validate-xml-with-schemalocation/

<p style="color: grey"> Python recipe 578503 by <a href="/recipes/users/4185910/">Mathias Loesch</a> (<a href="/recipes/tags/schema/">schema</a>, <a href="/recipes/tags/schemalocation/">schemalocation</a>, <a href="/recipes/tags/validation/">validation</a>, <a href="/recipes/tags/xml/">xml</a>). Revision 3. </p> <p>Addresses problems described at:</p> <p><a href="http://stackoverflow.com/questions/2979824/in-document-schema-declarations-and-lxml" rel="nofollow">http://stackoverflow.com/questions/2979824/in-document-schema-declarations-and-lxml</a> <a href="https://mailman-mail5.webfaction.com/pipermail/lxml/2011-September/006153.html" rel="nofollow">https://mailman-mail5.webfaction.com/pipermail/lxml/2011-September/006153.html</a></p>

2014-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>