Subject Re: [Firebird-general] Re: Migration from Ms-sql to Firebird call to story
Author Philippe Makowski
Le 27/09/2006 13:15, maximshiryaev a dit :
> Hello.
>
> Some time ago I've been evaluating Alfresco - an opensource CMS. Its
> stack is this: MySQL -> Hibernate -> SpringFramework -> tomcat -> Web
> interface.
>
> Since all other systems in our company use Firebird as a database back-
> end I've decided to move Alfresco to Firebird.
>
> Here are the steps:
> - install FB2.0RC SS (Win32)
> - add JayBird jar to appropriate location
> - change connection string params in Alfresco xml configuration files
> - change Hibernate SQL dialect to FirebirdDialect in its properties
> files
>
> That's all. Hibernate creates all the required tables, etc.
>
good news, but I was talkin about Ms-SQL (Microsoft) not MySQL

do you contact the Alfresco team to put officially the Firebird support on their
roadmap ?

it is nice to have a one shot move, but if some day they use table name for
instance of more than 31 caracters, you will have some problem
(it is the case for example with vTiger)