topic Re: How can I run a database schema for MS SQL Server? in Alfresco Archive

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

gbaindl — Thu, 05 Jul 2007 17:30:23 GMT

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?

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

kevinr — Thu, 05 Jul 2007 17:47:06 GMT

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

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

gbaindl — Thu, 05 Jul 2007 19:41:22 GMT

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

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

mikeh — Thu, 05 Jul 2007 21:57:36 GMT

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

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

gbaindl — Thu, 05 Jul 2007 22:46:27 GMT

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.

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

davidc — Fri, 06 Jul 2007 09:12:13 GMT

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

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

mariuszdawczyk — Wed, 28 May 2014 15:59:24 GMT

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