topic Re: Alfresco 3 Stable oracle upgrade db script in Alfresco Archive

Alfresco 3 Stable oracle upgrade db script

skorde — Tue, 14 Apr 2009 06:29:28 GMT

HiI 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 errorThe schema script could not be found at location classpath:alfresco/dbscripts/upgrade/2.2/${db.script.dialect}/AlfrescoSchemaUpdate-2.2-ACL.sql Could you plea

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Tue, 14 Apr 2009 07:21:07 GMT

HI

Sorry, we no longer support upgrading to the Labs version with proprietary ("closed source") databases such as Oracle and MS SQL Server.

Thanks,
Mike

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Thu, 16 Apr 2009 14:17:13 GMT

Beautiful!

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Thu, 16 Apr 2009 14:28:30 GMT

Beautiful!

I'm assuming that's a sarcastic response..?

Without getting into an argument, we think it's reasonable that the "free and open" version of Alfresco works only with "free and open" application servers and databases. If you're willing to pay for a proprietary database then we believe you should be willing to pay for Alfresco too.

Mike

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Thu, 16 Apr 2009 14:40:42 GMT

Hello Mike

I'm sorry for this sarcastic comment, but I though it was the only way of catching your attention.. I've tried some questions before some important questions in the forum with no response at all.

My point is that we was using Alfresco 2.1 as a tecnology enabler in our organization and we are planning to upgrade to the commercial license soon; we are still using alfresco 2.1 and decided to evaluate alf3 to see if it's worth buying it given its enhancements… but when we tried to migrate it, it surprised us all with this restriction.

I don't know what other choice do we have.. maybe a commercial trial?

Thank you for your reply, and sorry again about the sarcasm!

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Thu, 16 Apr 2009 14:57:36 GMT

I don't know what other choice do we have.. maybe a commercial trial?

That would probably be your best option for an evaluation, yes. Although the Enterprise trials are 30 days by default, we have been known to extend these in the past; we realise some customers need longer to fully evaluate the new and changed features.

Thank you for your reply, and sorry again about the sarcasm!

No problem! :wink:

Thanks,
Mike

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Thu, 16 Apr 2009 15:13:56 GMT

By the way… I think Alfresco not only gets benefited by the money the users of the Enterprise pay… I think there's a lot of value in the contributions of the comunity.

Me and my people had made a lot of contributions to the Alf community… those contributions were possible because we Installed Alfresco using Oracle as our database. If Alfresco would tell us we can not use oracle, maybe our organization wouldn't have alfresco because of the administrative costs we would incur by installing a new data base. If an organization already has Oracle and decided use an ECM like Alfresco, the normal thing is to use that database, not use a new one, even if it's in evaluation time, wich could take normally more than 30 days as you said.

Re: Alfresco 3 Stable oracle upgrade db script

jdaristizabal — Thu, 16 Apr 2009 15:16:00 GMT

I'm not agree with the comment…

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

.

What I see is that you are forcing people to buy Alfresco just because they have a proprietary database. That is no free software… you should let them take the decision not force them to take it….

In my opinion you made a big mistake…

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Thu, 16 Apr 2009 15:24:19 GMT

Thanks for the feedback guys - I'll make sure the decision-makers are aware of this conversation.

Thanks,
Mike

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Thu, 16 Apr 2009 15:39:36 GMT

Thanks Mike, that would be great!

I forgot… customers could be using a non paying version of Oracle, so when you said

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

won't be necesarily true at all.

Re: Alfresco 3 Stable oracle upgrade db script

skorde — Fri, 17 Apr 2009 06:04:11 GMT

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

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Fri, 17 Apr 2009 15:55:04 GMT

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

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Fri, 17 Apr 2009 16:42:50 GMT

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

Thanks,
Mike

Re: Alfresco 3 Stable oracle upgrade db script

kiekie — Wed, 22 Apr 2009 12:18:22 GMT

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.

Re: Alfresco 3 Stable oracle upgrade db script

ale_carraro — Tue, 26 May 2009 14:46:36 GMT

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

Re: Alfresco 3 Stable oracle upgrade db script

jzulu2000 — Mon, 08 Jun 2009 20:54:58 GMT

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

Re: Alfresco 3 Stable oracle upgrade db script

skorde — Tue, 09 Jun 2009 04:59:44 GMT

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

Re: Alfresco 3 Stable oracle upgrade db script

sameer1sharma — Thu, 09 Jul 2009 13:13:18 GMT

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?

Re: Alfresco 3 Stable oracle upgrade db script

mikeh — Thu, 09 Jul 2009 13:39:00 GMT

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

Mike

Re: Alfresco 3 Stable oracle upgrade db script

sameer1sharma — Thu, 09 Jul 2009 13:58:31 GMT

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