On Thu, Feb 20, 2014 at 1:31 PM, emilio lorenzo <[email protected]> wrote:
>
> 1. Change JDBC connectors on dspace.cfg
> 2. Migrate the database (any tips or advices on this point?)
> 3. Recompile ?
>
> No need to rebuild. You "only" need to change the configuration (db.name,
> db.url, db.driver, db.username, db.password, db.schema)
and transfer the data. Migrating the data will be where all the fun is at.
I'm not aware on any notes that document this mostly manual process
completely, but see below for some notes and opinions. I ranked them from
the most to least useful.
In general I would attempt the process this way:
1) pg_dump the data
2) create a fresh DSpace DB in Oracle
3) it might be necessary to drop some constraints in Oracle
4) the fun step - attempt to import each table, correcting the data for
difference in column types as you go
5) attempt to reinstate constraints
6) if all looks well, run update-sequences.sql
7) point DSpace to Oracle and restart it
8) test, test, test
Keep in mind that I have never attempted this.
http://dspace.2283337.n4.nabble.com/DSpace-database-migration-from-Postgres-to-Oracle-td3278996.html#a3278997
http://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
http://blogs.exeter.ac.uk/openexeterrdm/blog/2012/05/25/dspace-our-repository-software/
http://en.it-usenet.org/thread/11494/3557/
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
