DB-Scripts for MS SQL Server needed

[gbaindl]

Has everyone built the db-scripts (create, …) for MS SQL Server? If I startet the file "AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-64635.sql" I get many error and I'm not a SQL Specialist for the different SQL-Types.

[mikeh]

http://forums.alfresco.com/viewtopic.php?t=7294

[davidc]

You need to change Alfresco's sql dialect to SQL Server.  It's much easier.

http://wiki.alfresco.com/wiki/Database_Configuration

[gbaindl]

Hi David,

thanks, but this is what I did. Here is the configuration in repository.properties:

# Database configuration MS SQL Server
db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://xxx.web-shuttle.de:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

The alfresco start file can connect to the database, but it runs the mysql-comands and this brings up an error.

I would be good, if there is a detailed installation documentation about eyery step and change in every file. So I can reinstall Alfresco.

Thanks for your help.

Georg

[davidc]

You're missing the dialect config.  The configuration steps are listed in the URL I pasted earlier.  There's also a link to the list of dialects for all databases.

[gbaindl]

Now I found the wrong thing. I forgot to copy the jtds-1.2.jar File to the lib Folder. Now it runs with MS SQL Server. Thank you fpor your help

Georg  

[akshayakher]

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

[nick_gti]

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

Here is how i got it to work.

Also please note this was a fresh install of alfresco 2.1RC1 on windows 2003 server.

First edit the custom-hibernate-dialect.properties located in the tomcat\shared\classes\alfresco\extension folder.
Contents of my file.

# Sample Hibernate configuration to disnable Hibernate schema updates
# Values are "validate" or "update" (default)
#hibernate.hbm2ddl.auto=validate

#
# Microsoft SQL dialect
#
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
‍‍‍‍‍‍‍‍‍

Second edit custom-repository.properties
added to the file:

db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20
‍‍‍‍‍‍‍‍‍‍

Third copy the jtds-1.2.jar file you download to \tomcat\common\lib\

Forth: I made a new database using sql enterprise manager called Alfresco
Created a sql user account named alfresco that is a member of the Alfresco database and had system administration role.

Once this is all done i started alfresco up and it ran the scripts and i was ready to go.

[akshayakher]

Thank you so much. I will try and implement this.

Regards
Akshaya

[akshayakher]

one more clarification.

jtds-1.2.jar file you would be getting when we download tomcat right or when we download alfresco?

Also will this whole setup work with Alfresco 2.0

Thanks a lot for your help.

Regards
Akshaya