How can I upgrade from Alfresco 3 to 5... Also how can I get current config and document repo from 3 to 5 ? Also How can I get alfresco 5 to use currently inuse SQL server alfresco database ?

[stevie5194]

How can I upgrade from 3 to 5 ?

How can I get current config and document repo from lab 3 to new 5.1 ?

How can I get alfresco 5.0 to use already and currently used ALFRESCO database?

How can I integrate alfresco 5.0 with windows application ? not a website.

if I cant use SQL SERVER, How can I use a .BAK file to restore a database to PostgreSQL database ?

I am finding alot of difficulties configuring the new Alfresco and integrating it with SQL server as well as the document repo backup already taken in addition to integrating with the windows application I am trying to integrate it with.

All using Alfrescon Community 5.1

[afaust]

The documentation contains information about supported upgrade paths. Basically you need to update in multiple steps. For each major version and then the final 5.1 minor release. You also need to update your database to have a supported platform (please note that this link relates to Enterprise Edition, but can be used as reference for Community Edition too).

Alfresco Community Edition does not support using MS SQL server. You need to use either MySQL, Maria DB or PostgreSQL. There is no simple migration from MS SQL to a PostgreSQL database, if that is what you where asking. You would likely need to hire a DB expert or find a tool to support you in converting an export so that it can be loaded into PostgreSQL.

You should create separate questions for your difficulties regarding integration and provide as much detail as possible. Currently, there is little to go on in that regard.

[cesarista]

In this post of Angel Borroy , there is a useful high level flowchart for a migration:

Our way from Alfresco 4.2.c to Alfresco 5.0.c | Programming and So

In addition to Axel Faust​ comments, take into consideration if your custom modules or integrations are compatible with SOLR eventual consistency.

Regards.

--C.