Alfresco 3 Stable oracle upgrade db script

[skorde]

Hi
I am using alfresco 2.1 CE with oracle db and I want to upgrade it to Alfresco 3 Stable version.While upgrade , I am getting following error

The schema script could not be found at location classpath:alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/AlfrescoSchemaUpdate-2.2-ACL.sql

Could you please provide me oracle upgrade schema script so that I can upgrade my community version to stable version

[skorde]

Have a look at John Newton's thoughts over the closed source database support

http://newton.typepad.com/content/2009/03/building-a-stronger-open-source-product.html

[jzulu2000]

One more question… are you planning to remove the MySQL migration scripts from the Labs version?

As far as I know, MySQL has a non-comunity version and many alfresco users could be using it… As MySQL, who has a free and an pay version, Oracle does too..

Thanks

[mikeh]

It's not a matter of how much you pay for it: MySQL is open source, whereas Oracle is not.

Thanks,
Mike

[kiekie]

If you say

It's not a matter of how much you pay for it: MySQL is open source, whereas Oracle is not.

i think it against what you said earlier

If you're willing to pay for a proprietary database then we believe you should be willing to pay for Alfresco too

Coz you talking about money here.

Its up to you/alfresco team, if you want to be opensource or not opensource, free or not free,  support something or not support something, but at least, in your release annoucement, or in your release plan (if possible),  you mentioned if you dont want to support specific database what ever the reason is.
By doing that users that using your product aware about that, and they can decide and plan what they have to do.

[ale_carraro]

Btw, it seems that Hypersonic is no longer supported, too  :cry:

[jzulu2000]

Maybe downloading enterprise version and extracting the oracle scripts it will work…

[skorde]

No , it will not work bca we don't know exact version of Alfresco Enterprise which will map with Alfresco Stable

[sameer1sharma]

Hi Mike,
           Suppose I'll buy alfresco lab3 then Can I connect it with oracle 11g. Can you give support for alfresco labs3 with oracle 11g?

[mikeh]

Depends what you mean by "support" - these forums are support for the Labs / Community versions.

Mike

[sameer1sharma]

Hi Mike,
          I'm trying to upgrade from alfresco 2.1 ce to alfresco labs3 CE. I'm using oracle 11g as db. When I'm trying to upgrade I'm getting error. I'm unable to upgrade if I'm using Oracle as our db, however I'm able to upgrade if I'm using MySQL as my database. I tried all the information found on the net to upgrade while using Oracle as my database but nothing worked. Please suggest me some way so that I can migrate from alfresco 2.1 to alfresco labs3 using oracle as my db.
Please reply ASAP.
:-Sameer