[ic] Database Conversion

[Mark Johnson]

Walid Shaari wrote:
> 
> Hi All,
> Is it possible to convert from a gdbm database to mysql/postgresql ?
> as we have am interchange catalog that is already using gdbm.

Yes.

If you start by installing foundation or construct using the
mysql/postgres option, you should be able to figure it out. The process
is both trivial and fairly extensive, but in a nutshell:
(1) set MYSQL/PGSQL to 1, SQLUSER and SQLPASS to their respective
values, in variable.txt
(2) set SQLDSN to the DBI connect string in catalog.cfg (will see an
example in a demo)
(3) find the folder under catroot/dbconf that relates to your db and
follow the examples there for table configuration (this will be the most
labor-intensive part if you've changed your table structure
substantially from the default config for whatever catalog you used as
your base install).
(4) Make sure you create the necessary database FROM THE SHELL before
you try to load IC tables into it.
(5) Restart

-- 
Mark Johnson
Senior Systems Architect - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912