[opencms-dev] opencms and ms-sql server 2000

[Andras Balogh]

Hello,
Salvatore Sciacco wrote:

>Hi,
>
>I'd like to use opencms with ms-sql server. There is anybody there
>which can share his experience (positive or negative) with that DB?
>  
>
    Not so long ago there was a discussion about this and some people 
(including me)
from the list offered to add the support for ms-sql also in OC6, meaning 
that at setup
process to be possible to choose "MS-SQL DB".
    The ms-sql support is not ready yet, i think most of the people who 
offered help
are  doing other (more important) tasks that is why there is no result yet.

>Also it seems that the script to create tables in the generic
>directory is broken (ie in the CMS_BACKUP_PROJECTS table there is a
>primary key constraint that use the column VERSION_ID which isn't
>defined in the table), and it use  ORACLE data type, not so "generic"
>.
>
>I'm using the version 6.0beta3 (anyway I'm downloading the RC1 just now)
>
>Thank you in advance for your help.
>
>Bye
>
>Salvatore
>  
>
Best regards,
Andras.