I have try this morning to upgrade my instance of ST 11 to the version 12 with the Upgrade.aspx wizard but the SQL Script is not compatible with Azure.
I got an error message :
'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
Problem: System.Data.SqlClient.SqlException (0x80131904): 'Filegroup reference and partitioning scheme' is not supported in this version of SQL Server.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQueryWithWait(String query, SqlParameter parameters)
at SmarterTrack.Data.Database.CreateTableTask.Execute(DBProperties props)
Based on the research I have done the "ON [PRIMARY]" is not supported on Azure. I have install a local version to compare the DB Schema and upgrade manually on a sandbox server my database but the upgrade script didn't look at the structure it self. Somewhere a lock is present I guess.
It is possible to have a new bundle without this ON [PRIMARY] or is it a trick to fix it ?
I saw the new database schema version number in the parameters tables but as well if I change it, nothing change in my upgrade.aspx process.
Is there any possibility to have the upgrade process Azure compliant ?
I propose for a future release to have the SQL upgrade process outer the DLL so it's simpler to update it.
Artionet Web Agency | Director - Strategic Consultant Route de Moutier 109 | CH-2800 Delémont | Switzerland www.artionet.com Website, CMS, e-Commerce, e-Gov, Social News Room