How can I run a database schema for MS SQL Server?

[gbaindl]

I find some hints for configuration of the config files "Create a new 'alfresco' user and schema in DB xxxx", but where can I find the sql-scripts to create the alfresco database?

[kevinr]

For the bundles i think there are in:
\extras\databases\mysql

So you would need to modify them slightly for SQL Server - i doubt it's hard. The actual DB tables are created automatically by the Alfresco server when it first starts.

Thanks,

Kevin

[gbaindl]

Here ist the content of db_setup.sql:

create database alfresco;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

I think this is not what I need

Georg

[mikeh]

Yes, that sql is specifically for MySQL, so it's won't work with SQL Server.

By far the easiest option is to use either of Microsoft's tools: Enterprise Manager or Query Analyser, that came with your SQL Server installation. If they're not installed by default, check your installation CD/DVD - they may be under "client tools".

Thanks,
Mike

[gbaindl]

Hi Mike, thank you for your answer. I have Enterprise Manager and Query Analyser and I "translated" the file "AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-64635.sql" to MS SQL Server dialect. I run it  with Query Analyser and now I have the database. But if I start Alfresco there is a error because Alfresco runs a db-script for mysql. I spent a lot of time to run Alfresco with MS SQL Server, but I hasn't any success. Sorry, but I'm not a database specialist.

[davidc]

See http://forums.alfresco.com/viewtopic.php?p=23841#23841

[mariuszdawczyk]

Do You have alfresco AMP for MS SQL 2012? I have alfresco 4.2.f