Metacat

   You now need to set up the table structure in your database.  You can do

   either do this using the ant build system, or by manually running the

   scripts using a sql utility.

  </p>

  <p>To run the scripts using ant, type "ant installdb".

  </p>

  <p>To run the scripts manually, change to the

  </p>

  <p>Either way, 

   you should see a bunch of output showing the creation of the Metacat table

   xmltalbes_postgres.sql and for Microsoft SQL server is 

   xmltables-sqlserver.sql.

  <p class="header"><h2>Upgrading SQL Scripts</h2></p>

  <p>

    If you have an existing metacat installation, you should not run the install

    script because it will replace all of the older tables with new, empty 

    copies of the tables.  Thus you would lose your data!  Instead, you can 

    run some upgrade scripts that will change the table structure as needed for

    the new version.  If you are skipping versions, run each upgrade script

    for the intermediate versions as well.  Currently the upgrade scripts are:

   </p>

    <ul>

      <li>upgrade-db-to-1.2.sql</li>

      <li>upgrade-db-to-1.3.sql</li>

    </ul>

   <p>

    So, if you had an existing metacat 1.0 installation and you were upgrading 

    to 1.3, you would need to run both upgrade-db-to-1.2.sql and 

    upgrade-db-to-1.3.sql. Howver, if you were starting from a Metacat 1.2.x

    installation, you would only need to run the 1.3 upgrade script.

   </p>

  </p>