This is a follow-on post from, How The Episerver 'Installation' And 'Update' Powershell Functions Work Under Da Hood that will allow you to run the Episerver SQL update scripts from your build server. Episerver provides two useful PowerShell functions that you can call within your Nuget Package Management Console that will install all the tables and stored procedures required by Episerver in order to create a fresh database. If you try and run these scripts manually though, SQL will moan and fail. In today's guide, I'll show you how you can get these scripts to work!
You can probably use Episerver for a while before you bump into epideploy. The 'epideploy.exe' tool comes as part of the Epi Framework. When you add the Episerver.Core Nuget package into your solution, if you look within your Epi framework packages folder, as seen below, you should be able to find it within the 'tools' directory:
Export-EPiUpdates is a PowerShell function provided by the Episerver to help you upgrade your SQL database when you upgrade Episerver. Export-EpiUpdates will export all the SQL scripts required to upgrade a database to the latest version for the CMS, Episerver Find and Episerver commerce. Export-API updates will create a new folder with 'epideploy.exe', a batch file and all the scripts required:To upgrade your database, you simply call the batch file passing in the path to your website, sort of something like this if you're doing it in C#:
cmd C:\EPiUpdatePackage\update.bat C:\webroot
Upgrading your Epi-database is pretty simple. In a perfect world, then maybe the upgrade path could create one giant superscript you could simply run against SQL but this process is much better than the majority of CMS platforms out there. In the next tutorial I'll go over a small deployment application I created that fully automates this process, enjoy!
Software Architect, Programmer and Technologist Jon Jones is founder and CEO of London-based tech firm Digital Prompt. He has been working in the field for nearly a decade, specializing in new technologies and technical solution research in the web business. A passionate blogger by heart , speaker & consultant from England.. always on the hunt for the next challenge