topic Activiti on MS SQL 2005 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/activiti-on-ms-sql-2005/m-p/46310#M25964 <HTML><HEAD></HEAD><BODY><SPAN>Hello. I would like to ask, whether there is a planned support for this database. Currently I can't run Activiti on it, because I can't create the schema. activiti.mssql.create.engine.sql and activiti.mssql.create.history.sql scripts will fail on MSSQL 2005, as in "create unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) where BUSINESS_KEY_ is not null;" the "…where BUSINESS_KEY_ is not null" is not supported.</SPAN><BR /><SPAN>How important is this unique index ? Could Activiti run without it ? I did not research the purpose of this table and index, but would I maybe be able to check that constraint programatically myself ? </SPAN><BR /><SPAN>I really have no other option, that to use MSSQL 2005, which makes my heart bleed, because if I won't be able to get Activiti up&amp;running, I'd probably have to switch to jBPM 4.4, cos of jBPM 5's poor Spring integration. Thanks for any help/advice.</SPAN></BODY></HTML> Wed, 01 Jun 2011 12:08:34 GMT seges 2011-06-01T12:08:34Z Activiti on MS SQL 2005 https://connect.hyland.com/t5/alfresco-archive/activiti-on-ms-sql-2005/m-p/46310#M25964 Hello. I would like to ask, whether there is a planned support for this database. Currently I can't run Activiti on it, because I can't create the schema. activiti.mssql.create.engine.sql and activiti.mssql.create.history.sql scripts will fail on MSSQL 2005, as in "create unique index ACT_UNIQ_RU_BU Wed, 01 Jun 2011 12:08:34 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-on-ms-sql-2005/m-p/46310#M25964 seges 2011-06-01T12:08:34Z Re: Activiti on MS SQL 2005 https://connect.hyland.com/t5/alfresco-archive/activiti-on-ms-sql-2005/m-p/46311#M25965 <HTML><HEAD></HEAD><BODY><SPAN>The QA for MSSQL will be set up this month, so any issues with it, will come out. The index you are referring to is to ensure a business-key is unique throughout process-instances. If you do not use the business-key (it's an ID you optionally specify when starting a process instance, to identify the process with an ID that has a meaning for you) it's safe to remove the index…</SPAN></BODY></HTML> Mon, 06 Jun 2011 08:07:31 GMT https://connect.hyland.com/t5/alfresco-archive/activiti-on-ms-sql-2005/m-p/46311#M25965 frederikherema1 2011-06-06T08:07:31Z