topic Re: SQL SERVER...configuration in Alfresco Archive

SQL SERVER...configuration

sgomes — Wed, 30 May 2007 08:58:37 GMT

Hi!i have alfresco running in Jboss Server 4.0.5 with mySQL database.where i can get a script…to create all tables in SQL SERVER, like alfresco have to mySQL ??thanks

Re: SQL SERVER...configuration

mikeh — Wed, 30 May 2007 10:48:45 GMT

Hi,

You shoudn't need to manually create the tables, just the alfresco database.

Check the wiki: http://wiki.alfresco.com/wiki/Database_Configuration
and this forum topic: http://forums.alfresco.com/viewtopic.php?t=5828

for tips on configuring Hibernate with SQL Server.

Thanks,
Mike

Re: SQL SERVER...configuration

sgomes — Wed, 30 May 2007 13:46:38 GMT

Thanks for your help!

To create database Alfresco in my SQL Server… i try to use the script that comes with alfresco…. /extras/databases/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;

but does not work in SQL SERVER….

can you help me?

Thanks

Re: SQL SERVER...configuration

mikeh — Wed, 30 May 2007 14:21:32 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