Metacat

    <div class="toc1"><a href="#TestDbVersions">Testing Different Database Schema Versions</a></div>

      <div class="toc2"><a href="#scripts">Scripts to Run</a></div>

      <div class="toc2"><a href="#checkoutScripts">Get Scripts Via Checkout</a></div>

      <div class="toc2"><a href="#scriptRepo">Script Repository</a></div>

  <a name="TestDbVersions"></a><div class="header1">Testing Different Database Schema Versions</div>

  <p>Now and again it is necessary to restore your test database to an older schema version

  either because you need to test upgrade functionality, or you need to test backwords 

  compatibility of code.  This section describes how to get your db schema to an older 

  version.

  <a name="scripts"></a><div class="header2">Scripts to Run</div>

  <p>It is assumed that you have an empty metacat database up and running with a 

  metacat user.

  <p>There are two types of scripts that need to be run in order to create a Metacat

  schema:</p>

  <ul>

  <li>xmltables-&lt;dbtype&gt;.sql - where &lt;dbtype&gt; is either oracle or postgres

  depending on what type of database you are running against.  This script creates the

  necessary tables for Metacat.</li>

  <li>loaddtdschema-&lt;dbtype&gt;.sql - where &lt;dbtype&gt; is either oracle or postgres

  depending on what type of database you are running against.  This script creates the

  necessary seed data for Metacat.</li>

  </ul> 

  <a name="checkoutScripts"></a><div class="header2">Get Scripts Via Checkout</div>

  <p>One way to get the scripts you need is to check out the release tag for the version

  of metacat that you want to install.  You can then run the two scripts shown above to

  create your database.</p>

  <a name="scriptRepo"></a><div class="header2">Script Repository</div>

  <p>For convenience, the scripts to create each version have been extracted and 

  checked into:</p>

    <div class="code">&lt;metacat_code&gt;/src/scripts/metacat-db-versions</div>

  <p>The files look like:</p>

  <ul>

  <li>&lt;version&gt;_xmltables-&lt;dbtype&gt;.sql - where &lt;version&gt; is the version

  of the schema that you want to create and <dbtype> is either oracle or postgres

  depending on what type of database you are running against.  This script creates the

  necessary tables for Metacat.</li>

  <li>&lt;version&gt;_loaddtdschema-&lt;dbtype&gt;.sql - where &lt;version&gt; is the version

  of the schema that you want to create and <dbtype> is either oracle or postgres

  depending on what type of database you are running against.  This script creates the

  necessary seed data for Metacat.</li>

  <li>&lt;version&gt;_cleanall-&lt;dbtype&gt;.sql - where &lt;version&gt; is the version

  of the schema that you want to create and <dbtype> is either oracle or postgres

  depending on what type of database you are running against. This is a convenience script

  to clean out the changes for that version.</li>

  </ul>

  <a name="scriptRepo"></a><div class="header2">Manually Run Scripts</div>

  <p>For instructions on running database scripts manually, please refer to:

  <a href="../user/run-db-scripts.html">how to run database scripts</a></p>