CRIAR BASE SQL SERVER 2008

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ronnie_6602

Caros, estou tentando conectar o Alfresco no SQL Server 2008, porém, pesquisei na net e aqui no fórum e não consegui fazer.

Após instalado com Mysql, preciso importar as tabelas do mysql??? ou possuo algum script para isso??

ps* já efetuei as configurações necessárias no .properties e já criei a base alfresco no sql server.
Agradeço!


Atenciosamente,
Ronnie Santos

williamsilva

Caros, estou tentando conectar o Alfresco no SQL Server 2008, porém, pesquisei na net e aqui no fórum e não consegui fazer.
Alfresco no MS-SQL Server somente na versão Enterprise
Microsoft SQL Server example

Requires Enterprise Edition. The following are example steps only and are subject to change:

    * create an alfresco database and corresponding user, with sufficient rights on the database (to create tables etc).

    * Issue the following command to enable snapshot transaction isolation mode.

ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;

    * Ensure TCP connectivity is enabled on fixed port 1433

    * Copy the jTDS v1.2.5 JDBC driver to $TOMCAT_HOME/lib

    * Edit alfresco-global.properties and add/update the following entries:

db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=localhost
db.port=1432
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://{db.host}:${db.port}/${dbname}
db.txn.isolation=4096

    * Start the application server (eg. Tomcat) to verify your configuration changes.
Fonte.:http://wiki.alfresco.com/wiki/Database_Configuration
sds.