deploy content to any database on portal side?

[hansraj]

Hi,

Iam using Alfresco Labs3. As we know Derby is the default DB we get thru this installation.
My requirement is, i want to deploy my content to diffrent DB like MS-SQL/Oracle. can we do this ?
If so, please tell me the procedure to do this.

If i use Enterprise Edition, can i do the deployment of content to different DBs?

Regards,
Hansraj

[mrogers]

Yes you can use other databases

There are guides on the wiki such as:
http://wiki.alfresco.com/wiki/Database_Configuration

[hansraj]

Hi,

Thank you very much for your reply.  It's really useful for me.

Now i came to know that we can configure different DB in Alfresco Labs. I followed the wiki guide as you said.

My requirement is something more. Please tell me the procedure how to do content deployment to the configured DB.
For eg, iam going to configure Oracle, could you please tell me how to do deployment to Oracle DB?


Regards,
Hansraj

[mrogers]

Could you clarify what you mean by deployment please?

[hansraj]

Hi,

Thank you very much for ur reply.

My requirement was deploying content from one machine(alfresco + derby) to another machine(alfresco + oracle) within the same network and then fetch the content from db thru a jsp page.

please clarify the following regarding my above requirement -

1). when i configured alfresco with Oracle(as per the above wiki guide), iam getting port(8080) clash between Tomcat and Oracle. How to configure Tomcat to diffrent port otherthan 8080?

2). what is the database logic to be writtten in jsp to fetch content from db (Oracle)?


Regards,
Hansraj

[hansraj]

Hi,

how to deploy content (i.e. insert content) in to a custom table ?

Regards,
Hansraj