Latest recipes tagged "schema" Code RecipesValidate XML with schemaLocation (Python) 2013-03-28T10:24:55-07:00Mathias Loesch <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="" rel="nofollow"></a> <a href="" rel="nofollow"></a></p> Dump Informix schema to text (Python) 2014-02-21T09:16:15-08:00Michal Niklas <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="" rel="nofollow"></a></p> <p>Oracle: <a href="" rel="nofollow"></a></p> Dump PostgreSQL db schema to text (Python) 2014-02-21T09:17:23-08:00Michal Niklas <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=""></a></p> Dump Oracle db schema to text (Python) 2014-02-21T09:18:55-08:00Michal Niklas <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="" rel="nofollow"></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>