[Koha] Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to aDebian/MySQL system. Any suggestions as to how to go aboutthis?? Thank for the input. Todd Goatley

[Ian Bays]

Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go about this?? Thank for the input. Todd GoatleyHi Todd,
To get the bibliographic, item and user/borrower data you will be far better off using the SirsiDynix (is it Unicorn/Symphony?) tools to get the data out.  If you have command-line access to your old system this will include using selcatalog, catalogdump and seluser with dumpflatuser.  Then they will need a bit of manipulation to get into the format expected by Koha for importing bibliographic, item and borrower data.

If you plan to take lots of datasets across then extracting from Oracle and into Mysql sounds like a good bet.

I won't go into the detail of those commands here but do come back if you have any specific questions.

Good luck.

Ian
  ----- Original Message ----- 
  From: Goatley, Todd 
  To: koha at lists.katipo.co.nz 
  Sent: Tuesday, February 24, 2009 8:57 PM
  Subject: [Koha] Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to aDebian/MySQL system. Any suggestions as to how to go aboutthis?? Thank for the input. Todd Goatley




  Trying to import from a RHEL/Oracle 10g (Sirsidynix) db to a Debian/MySQL system. Any suggestions as to how to go about this?? Thank for the input.



  Todd L. Goatley DCAS 
  Washoe County Library - Spanish Springs 
  7100A Pyramid Lake Highway 
  Sparks, NV 89436 
  Email: tgoatley at washoecounty.us 
  W: 775-424-1843 
  C: 775-771-3489 



------------------------------------------------------------------------------


  _______________________________________________
  Koha mailing list
  Koha at lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha



------------------------------------------------------------------------------



  No virus found in this incoming message.
  Checked by AVG - www.avg.com 
  Version: 8.0.237 / Virus Database: 270.11.3/1969 - Release Date: 02/24/09 06:43:00
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090225/90faa6f3/attachment.htm