Migrating your bibliographic records

Convert your MARC21 binary records into the MARCXML format, with one record per
line. You can use the following Python script to achieve this goal; just
install the pymarc library first, and adjust the values of the input and
output variables as needed.

Once you have a MARCXML file with one record per line, you can load the records
into your Evergreen system via a staging table in your database.

Connect to the PostgreSQL database using the psql command. For example:

psql -U <user-name> -h <hostname> -d <database>

Create a staging table in the database. The staging table is a temporary
location for the raw data that you will load into the production table or
tables. Issue the following SQL statement from the psql command line,
adjusting the name of the table from staging_records_import, if desired:

Create a function that will insert the new records into the production table
and update the dest column of the staging table. Adjust
"staging_records_import" to match the name of the staging table that you plan
to create when you issue the following SQL statement: