[Dspace-tech] Differences in db with upgrade and fresh install

2009-12-15 Thread Brouns, Francis
Hi,

We are in the process of upgrading from Dspace 1.4.2 to 1.5.2, at the same time 
moving from Postgresql to Oracle. When I perform an upgrade from 1.4 to 1.5.2 
and run the database_schema_142-15.sql on Postgresql the tables history and 
history_state are dropped. However, when I do a clean install of an Oracle 
database from database_schema.sql (1.5.2) the tables history and history_state 
are created. In the Postgresql database_schema.sql (1.5.2) those tables are not 
created. It is save to assume that both tables are no longer required?

Best wishes,
Francis Brouns
Open Universiteit Nederland
--
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Differences in db with upgrade and fresh install

2009-12-15 Thread Larry Stone
I just noticed that too, while contemplating a switch from Oracle to  
PostgreSQL.  The Oracle schema also still has the mets_bitstream_id  
column in the Bundle table, which is no longer used and has been  
dropped.

I'll start a JIRA issue to fix this.

(OBTW, before you switch over to Oracle, you ought to be aware that  
many DSpace tables use CLOBs, and those can make life very difficult  
because most of Oracle's own tools (e.g. SQL*Plus) don't work with  
them.)

thanks,

   -- Larry

On Dec 15, 2009, at 5:02 AM, Bram Luyten wrote:

 Hello Francis,

 these tables are indeed deprecated and not in use anymore.

 best regards,

 Bram

 @mire - http://www.atmire.com

 Technologielaan 9 - 3001 Heverlee - Belgium
 533 2nd Street - Encinitas, CA 92024 - USA

 http://www.togather.eu - Before getting together, get t...@ther


 On Tue, Dec 15, 2009 at 10:50 AM, Brouns, Francis francis.bro...@ou.nl 
  wrote:
 Hi,

 We are in the process of upgrading from Dspace 1.4.2 to 1.5.2, at  
 the same time moving from Postgresql to Oracle. When I perform an  
 upgrade from 1.4 to 1.5.2 and run the database_schema_142-15.sql on  
 Postgresql the tables history and history_state are dropped.  
 However, when I do a clean install of an Oracle database from  
 database_schema.sql (1.5.2) the tables history and history_state are  
 created. In the Postgresql database_schema.sql (1.5.2) those tables  
 are not created. It is save to assume that both tables are no longer  
 required?

 Best wishes,
 Francis Brouns
 Open Universiteit Nederland
 --
 Return on Information:
 Google Enterprise Search pays you back
 Get the facts.
 http://p.sf.net/sfu/google-dev2dev
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech

 --
 Return on Information:
 Google Enterprise Search pays you back
 Get the facts.
 http://p.sf.net/sfu/google-dev2dev
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech


--
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech