[Koha] Regarding the Oracle/MySQl data import. Thanks. HELP!!

Goatley, Todd TGoatley at washoecounty.us
Thu Feb 26 12:48:20 NZDT 2009


Hi Ian,
You are so responsive...it's great!! And yes, I am new. We just finished
the upgrade from Unicorn to Symphony (it seems as though we have wasted
a lot of money and time but we are getting on track trying to implement
Koha (we figure about 1 year). We have two servers with Koha (Lenny with
Koha 3.0) one is virtual and one is just a desktop server for testing. 
We are using the MySQL Migration Toolkit (
https://www.regnow.com/softsell/nph-softsell.cgi?item=5160-30 ). I
create a *.dmp file when doing an export from our Unicorn production to
test server and have imported the dump file from our Symphony test
server to the Koha MySQL using the migration tool. 
So...we imported the Oracle-Sirsi data into the Koha-MySQL but,
now...how do we set it up? I don't get how to create the Koha db and
what formats to apply. We did not the test db on the virtual Koha...do
you recommend doing it? How about the tools that you are describing? Do
you have any information on how to do this from SD to Koha given our
setup? Man, any onformation you can give I would greatly apprecaite. We
are wanting to be rid of SD within the year..



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

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


More information about the Koha mailing list