topic Schema update issues on SQL Server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/schema-update-issues-on-sql-server/m-p/117612#M83048 <HTML><HEAD></HEAD><BODY><SPAN>I'm upgrading Alfresco 2.0 to 2.1, using Tomcat/MS SQL Server.&nbsp; I see that some schema upgrade scripts are being generated.&nbsp; I am trying to run these scripts on the db before starting the Alfresco server.</SPAN><BR /><BR /><SPAN>More specifically, I'm using SQL Server 2000.&nbsp; I know the scripts generated are for SQL Server 2005, so there may be some issues.</SPAN><BR /><BR /><SPAN>The line that I'm having trouble with is similar to this:</SPAN><BR /><BR /><SPAN>CREATE INDEX FKFFF41F9960601995 ON alf_access_control_entry (permission_id);(optional)</SPAN><BR /><BR /><SPAN>The key word "(optional)" is not being recognized.</SPAN><BR /><BR /><SPAN>I understand this keyword, when used in SQL Server 2005, let's the script continue and complete when errors are detected.</SPAN><BR /><BR /><SPAN>What is the alternative syntax to use in SQL Server 2000?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>-Q</SPAN></BODY></HTML> Mon, 26 Nov 2007 23:44:04 GMT qasimh 2007-11-26T23:44:04Z Schema update issues on SQL Server https://connect.hyland.com/t5/alfresco-archive/schema-update-issues-on-sql-server/m-p/117612#M83048 I'm upgrading Alfresco 2.0 to 2.1, using Tomcat/MS SQL Server.&nbsp; I see that some schema upgrade scripts are being generated.&nbsp; I am trying to run these scripts on the db before starting the Alfresco server.More specifically, I'm using SQL Server 2000.&nbsp; I know the scripts generated are for SQL Server 2 Mon, 26 Nov 2007 23:44:04 GMT https://connect.hyland.com/t5/alfresco-archive/schema-update-issues-on-sql-server/m-p/117612#M83048 qasimh 2007-11-26T23:44:04Z Re: Schema update issues on SQL Server https://connect.hyland.com/t5/alfresco-archive/schema-update-issues-on-sql-server/m-p/117613#M83049 <HTML><HEAD></HEAD><BODY><SPAN>After posting this question on the MS SQL forums, I was told that there is no equivalent syntax for "(optional)" in SQL Server 2000.</SPAN><BR /><BR /><SPAN>Rather than spending hours tweaking the scripts, I had to manually scan the scripts and compare them to the existing SQL data/indices.&nbsp; I commented out the lines that would have failed.&nbsp; Took about 20-30 minutes.</SPAN></BODY></HTML> Wed, 05 Dec 2007 19:37:00 GMT https://connect.hyland.com/t5/alfresco-archive/schema-update-issues-on-sql-server/m-p/117613#M83049 qasimh 2007-12-05T19:37:00Z