SQL SERVER...configuration

[sgomes]

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

[mikeh]

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

[sgomes]

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

[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