This repository has been archived by the owner on Aug 17, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 72
Database
Mark McDonald edited this page Jul 9, 2021
·
2 revisions
The site uses a SQL Server Express 2017 LocalDB database. By default Visual Studio 2019 ships with SQL Server Express 2016 LocalDB.
You can resolve this by installing SQL Server Express 2017 LocalDB or greater from Microsoft: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15
The 2012 (v11.0) database is still available in the App_Data folder with the name 'EPiServerD_aefc3fcd' and can be used by following these steps:
- Alter connectionStrings section in web.config so that it points to the v11.0 database:
<add name="EPiServerDB" connectionString="Data Source=(LocalDb) \MSSqlLocalDB;AttachDbFilename=|DataDirectory|EPiServerDB_aefc3fcd.mdf;Initial Catalog=alloydemokit;Connection Timeout=60;Integrated Security=True;MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />
- Change version in entityFramework section in 'web.config' to v11.0_
- Update the database to the latest schema by using the Update-EpiDatabase function after updating to the latest Episerver packages. See the 'Updating configuration and database schemas' section on the page_ https://world.episerver.com/documentation/Items/Installation-Instructions/Installing-Episerver-updates/ for more information_