[gradebook2-dev] correct oracle conversion sql?

[Steve Jaegle]

Hi Thomas:

In my experience auto.ddl=true does not always work properly, though I have never taken the time to investigate why and how in our Oracle database. I have seen it produce incomplete changes or an incomplete database on at least two or three occasions; one of those times the database came up 14 tables short.  Knowing which file is the correct one allows me to make sure the changes have happened correctly.

Thanks,

Steve

On Fri, 8 Oct 2010 17:33:53 -0700, Thomas Amsler <tpamsler at ucdavis.edu> wrote:
> Stephen, 
> 
> 
> 
> If you start with v1.3.0 and you are not upgrading from an earlier version, then you don't need to run any conversion scripts. You would just set "auto.ddl=true" in sakai.properties so that all the gradebook2 related tables are created. 
> 
 
> 
> 
> 
> Best, 
> 
> -- Thomas 
> 
> 
> On Fri, Oct 8, 2010 at 5:07 PM, Stephen Jaegle  < sjaegle at mail.uri.edu >  wrote: 
> 
 Hi Folks: 
> 
 
> 
I have downloaded the gradebook2 1.3.0 tag and in the process of 
> 
preparing it for our Sakai 2.6.x/Oracle environment I notice that 
> 
there are two slightly different oracle database conversion sqls. I do 
> 
not have any earlier version installed. 
> 
 
> 
tags/1.3.0/sakai/2-6-x/INSTALL.txt refers to client/src/sql/oracle/gb- 
> 
datamodel-changes.sql, which does not seem to  exist, but there is a 
> 
client/src/sql/oracle/sakai_gradebook2.sql which will do the job. So 
> 
far so good, but there is also sakai/2-6-x/sql/oracle/ 
> 
sakai_gradebook2.sql, which is similar, but not the same. Based on 
> 
looking at the svn logs, diffing the files and greping about, it looks 
> 
like the sakai/2-6-x version is the one to go with, rather than the 
> 
client/src one. 
> 
 
> 
Please let me know if I'm wrong. If I am right I would be happy to 
> 
update INSTALL.txt, but I don't  know where or to whom to submit it. 
> 
 
> 
Thanks, 
> 
 
> 
Steve 
> 
 
> 
 
> 
 
> 
 
> 
 
> 
_______________________________________________ 
> 
gradebook2-dev mailing list 
> 
 gradebook2-dev at collab.sakaiproject.org 
> 
 http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev 
> 
 
> 
> 
>