Problem upgrading Commerce 1 R2 SP1 to R2 SP2
Just change your compability level on your database to SQL Server 2008 (100) and you'll be fine!
Edited,
Apr 20, 2012 9:36
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
I'm trying to update an existing EpiServer Commerce site from version R2 SP1 to R2 SP2, but each time I run the update I'm getting the following error:
An unhandled error has occured:
Incorrect syntax near 'merge'.
When executing
At C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Com
merce 1.1.2.62\ShareLib.ps1:93 char:26
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -Databas
eName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction:$avoi
dTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Password
False
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\ShareLib.ps1:93 char:26
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -DatabaseName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction:$avoidTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Password
System.Data.SqlClient.SqlException: Incorrect syntax near 'merge'.
at EPiServer.Install.SqlServer.Installers.SqlServerItemInstaller.HandleSqlException(SqlCommand cmd, SqlException ex)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.ExecuteSqlScript(String filePath, IDictionary parameters, IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.InstallInternal(IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.InstallationManager.Install(Installer installer)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.ExecuteDatabaseScript(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String scriptFilePath, Boolean avoidDbTransaction, Boolean isEPiServerScript, IDictionary parameters)
at EPiServer.Install.SqlServer.Cmdlets.ExecuteSqlScriptCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
Does somebody knows how to solve this problem?