[OPEN-ILS-DEV] ***SPAM*** RE: ***SPAM*** Re: ***SPAM*** New Server/Upgrade from 1.4 to 1.6

[Adam Ray]

Galen,

Thanks for the response.

One of the biggest problems we are having with the old installation is we have records we can look up by TCN, but won't show up in searches either in the staff client or OPAC. 

Regarding the DB upgrade scripts, where would I find the procedures for that?

Thanks,
Adam


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Galen Charlton
Sent: Thursday, May 13, 2010 2:20 PM
To: Evergreen Development Discussion List
Subject: [OPEN-ILS-DEV] ***SPAM*** Re: ***SPAM*** New Server/Upgrade from 1.4 to 1.6

Hi,

On May 13, 2010, at 11:59 AM, Adam Ray wrote:
> 1.       My biggest concern is what should be the order in which I proceed. Should I migrate data to a server running the same version of Evergreen and then upgrade the server or should I install 1.6 on the new server and then migrate the data?

Either approach would work.  What I would do personally is install 1.6 on the new server, bring over a database export from the 1.4 server, and run the database upgrade scripts, rather than going to the trouble of starting with a 1.4 install on the new server.

> 2.       How should I go about migrating the data in general? Are there scripts to move data from one server to another?

If you're generally happy with your data and the various configuration settings you applied in your 1.4 database, I would recommend just transferring your entire database (using pg_dump and pg_restore, for instance) rather than doing something like exporting your bib records and reimporting them into the new 1.6 database.  It depends on the nature of the 'flaws' you have in your original installation; if you truly do want to start from scratch and just reimport your bibs, you can do that.

Regards,

Galen
--
Galen Charlton
VP, Data Services
Equinox Software, Inc. / Your Library's Guide to Open Source
email:  gmc at esilibrary.com
direct: +1 352-215-7548
skype:  gmcharlt
web:    http://www.esilibrary.com/