Tag: Database
-
The element DataSyncEncryptionKey is not supported in Microsoft Azure SQL Database v12
Bump. Did you also get the following error after trying to export a database in Azure? Could not extract package from specified database. The element DataSyncEncryptionKey_XXX is not supported in Microsoft Azure SQL Database v12. I’ve had to contact Azure Support recently who were able to help me fix this problem. Even though there was…
-
Episerver Alloy – Could not open new database – File activation failure
Someone asked me today how to fix this error that he encountered after creating a new Episerver MVC project with the Alloy Template. I remember seeing this before myself and so I’m putting up a post for those out there who encounter the same problem. Server Error in ‘/’ Application. Could not open new database ‘EPiServerDB’.…
-
How to migrate SDF database to Sql Server
Umbraco’s site installation comes with an SDF database. For obvious reasons, I needed to migrate this to SQL Server. Below are the steps I took to make it work. Before proceeding to the steps below, you will need to install following: ExportSqlCE40.exe which you can download from here SQL Server Compact 4.0 Runtime from here…
-
Uploading a database to Azure using SQL Server Management Studio
Took me a while to find out, but deploying a SQL Server database to Azure is actually very easy. Make sure you have your Azure connection details ready! The below instructions / screenshots are from SSMS 2016. Should work for older versions too, although you might see different wordings. Open SQL Server Management Studio (SSMS) and…
-
Episerver – Could not find stored procedure ‘netCategoryListAll’
My scenario I tried creating a new database schema for my Episerver website that uses the createDatabaseSchema=”true” on the episerver.framework config node. This creates a new database schema if it detects there’s none for the database specified in the config. However, when I first ran my Episerver website which was configured to an empty database, I got the following error:…