Episerver Commerce Sql Version

Vote:
 

Hi 

We are starting a new Episerver Commerce project and have installed the version  9.23.0. 

Seems like the default database which is provided for commercer (in App Data folder) with this is SQL 2016. 

The folllowing system requirements mention that lowere versions are also supported.

http://world.episerver.com/documentation/Items/System-Requirements/system-requirements---episerver/

Is there a 2014 or lower version 2008 R2 available which we can use.

Would installing a lower version of EPiserver commerce provide us with this.

Kind Regards

Sandeep

#162183
Oct 12, 2016 10:48
Vote:
 

Hi,

The mdf file is set to SQL Server 2012 compatible level (Not 2016). If you have SQL Server 2014, just attach it and set the compatible level to 2008.

Regards,

/Q

#162187
Oct 12, 2016 11:40
Vote:
 

Hi Quan

Thanks for your repsonse. I am pretty sure the the default one which is being added in the App data folder of the main site when you use nuget packages to add commerce server to a cms site is a 2016 DB.

Please see the error message below when we try to attach the DB in our SQL.

"The database 'EcfSqlConnection_54905ff3' cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported.
Could not open new database 'EcfSqlConnection_54905ff3'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
Version 852 is 2016 as far as I am aware.
Please correct me if I am wrong.
Kind regards
Sandeep
#162189
Oct 12, 2016 12:01
Vote:
 

Hi,

Try to connect to (LocalDB)\MSSQLLocalDB, or SQL Server instance instead. I'm using SQL Server 2014 and I have absolutely no problem with attaching EPiServer.Commerce.dll to those two.

Regards,

/Q

#162190
Oct 12, 2016 12:14
Vote:
 

Hi Quan

Connecting to the database is not an issue. The following connection works fine for us without any issues and we can run the site and it is loading correctly.

<add name="EcfSqlConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|EcfSqlConnection_54905ff3.mdf;Initial Catalog=EcfSqlConnection_54905ff3;Connection Timeout=60;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

However in our production enviornment we would need to be able to attach the DB to in the SQL management studio (to an sql instance) to be able to setup maintenance scripts and running queries on tables.

You can download the dbs we have got from the following location and try to attach it in your SQl server instance and let us know if it works

http://www.giriksoftware.com/EcfSqlConnection_54905ff3.zip

http://www.giriksoftware.com/EcfSqlConnection_54905ff3_log.zip

Kind Regards

Sandeep

#162191
Oct 12, 2016 12:28
Vote:
 

Hi,

I honestly don't know about your file, but this is from my freshly installed site:

https://www.dropbox.com/s/8ku0t91rwavsmep/EcfSqlConnection_d40801bd.zip?dl=0

Regards,

/Q

#162192
Oct 12, 2016 12:44
Vote:
 

Could it be that the visual studio version and/or sql server version installed can affect this by changing properties on the mdf file when it is added/used in the project?

#162193
Oct 12, 2016 12:49
Vote:
 

Probably.

Perhaps you have SQL Server (Express) 2016 installed on your development machine and it automatically and silently upgraded the database to 2016 version when you installed the site.

#162195
Oct 12, 2016 12:52
Vote:
 

Hi Guys

Thanks for the input. Your analysis is most likely the case. I can restore the Db provide by Quan without any issues. Will check my local configuration and see where it is upgrading the database.

Thanks for your help on this.

Kind Regards

Sandeep

#162209
Oct 12, 2016 15:01
Vote:
 

Did you ever figure this one out? We're having the exact same problem.

#172040
Nov 24, 2016 11:26
Vote:
 

Hi Niklas

Yes, if you read the comments above. My machine had a different version of SQL express or similar attached to the visiual studio which was causing this issue when the sql scripts were being run.

I was able to use the version supplied by Quan above.

Kind regards

Sandeep

#172041
Nov 24, 2016 11:32
Vote:
 

Thanks. However, I was thinking of a more permanent solution, i.e. some way to prevent the database from being upgraded to 852 when installing the site.

#172043
Nov 24, 2016 11:52
Vote:
 

I had the same issue when I installed commerce site with Visual studio 2015 because VS 2015 data tools have SQL Server 2016 LocalDB installed on my PC. I have installed VS 2013 with data tools which installed SQL Server 2014 and 2012 LocalDBs. When installed commerce site usinbg visual studio 2013, I got the SQL data files(.mdf, .ldf) of SQL Server version 2014 and I am able to attach them on our customer's environment which has SQL Server 2014 running. Hope this helps someone facing similar issue.

#182600
Sep 26, 2017 4:11
Vote:
 

Niklas Uhlin,  You could use DbUp and script the database on live.

#183572
Oct 17, 2017 19:57