[OPEN-ILS-DEV] User data migration question

[Robert Soulliere]

Thanks, Mike and Karen for help with my last question. I think our
domain can now be accessed from the outside based on reports from one of
our offsite testers. First our IT department denied the problem, but
then they fixed it.   

My next question is looking more into the future. We will eventually
need to migrate our current student data into our Evergreen Database. I
think that this will be the most difficult and tedious task of all in
regards to migrating. The college uses Banner with an Oracle database
for student records. Is it possible to migrate from Oracle to PostgreSQL
directly? I heard that scripts will be required to massage the data into
PostgreSQL. I suspect that our IT department may have to work on this
part given security concerns with the student data. Our IT department is
not very open-minded about open-source software. 

Does anyone have any insights or experience to share regarding this user
record migration under these circumstances? I looked for discussion in
the archives but couldn't find very much on this topic. 

Thanks,
Robert 
  

----- Original Message -----
From: Mike Rylander <mrylander at gmail.com>
Date: Thursday, April 24, 2008 8:32 
Subject: Re: [OPEN-ILS-DEV] connecting outside of LAN

> On Thu, Apr 24, 2008 at 8:25 AM, Robert Soulliere
> <robert.soulliere at mohawkcollege.ca> wrote:
> > We installed the evergreen successfully on our test server and can
> >  connect to the evergreen server from inside the LAN and from 
> another>  University where we have a satellite campus. However, I 
> am unable
> 
> Congrats!
> 
> >  connect from my home network and one of my colleagues was also 
> unable to
> >  connect from here home. I was wondering if anyone could
> >  1) test to see if they can connect from their location to the 
> domain name:
> >  http://evergreen-server.mohawkcollege.ca/
> >
> 
> It's not letting me in from several locations on the 'net.
> 
> >  2) Let me know where else I could look to find out where the 
> problem is.
> >  I checked hosts.deny, hosts.allow all the apache configuration 
> files the
> >  hosts file and  anything else I thought would be related to a 
> webserver>  and web security. Is it something I need to contact my 
> campus web
> >  administrator about to open up access to the machine for the WWW 
> or is
> >  it something on the local machine?
> 
> This is definitely a campus IT issue.  They will most likely need to
> open the border firewall to allow traffic to the proper ports on your
> evergreen machine.  I wouldn't be surprised at all if your satellite
> campus simply has an all-access ruleset from their network block.
> 
> -- 
> Mike Rylander
> | VP, Research and Design
> | Equinox Software, Inc. / The Evergreen Experts
> | phone: 1-877-OPEN-ILS (673-6457)
> | email: miker at esilibrary.com
> | web: http://www.esilibrary.com
> 


This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message.  If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited.  If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.