Upgrading Litium Studio
Introduction
This document describes how to upgrade Litium Studio from version 4.2.0.0C to 4.3 on a web server.
Create backup
1. Backup the existing database
1.1. Open SQL Enterprise Manager or SQL Server Management Studio depending on which
version of MS SQL Server you are using (you will find the program in Windows start menu). 1.2. Find the current database; you will see it in the tree in the left panel.
1.3. Choose All Tasks ‐> Backup database; right click on the database and you will find the corresponding menu.
1.1. Below the Destination line press Add. Enter a valid path to backup the database to in the
new window.
1.2. Check that Backup type: Complete is selected.
1.3. If you plan to overwrite a ready existing backup, check that the Overwrite existing media is selected in the Options tab.
1.4. Press OK and wait for the backup to be complete.
2. OBS! Backup the whole web and file folder.
Update database
OBS! When the process has begun, the website is not accessible for users and all users that are logged in will be disconnected and logged out.
All script files will be in the compressed file Upgrade.zip in folder DB\Scripts
1. Open SQL Query Analyzer or SQL Management Studio depend of the version of MS SQL Server (you will find the program in windows start menu).
2. Login to MS SQL Server with permissions to administrate the database you are going to
upgrade. For each script you run, check that the correct database is used. (Query ‐> Change
database).
3. Open (File‐>Open) and run (F5) the script Foundation_UpgradeFrom42cTo43.sql.
4. After the script has executed, check the result panel after red error messages. If error is
exposed check error message and decide whether to rollback your backup or continue.
5. Open (File‐>Open) and run (F5) the script CMSUpgradeFrom42CTo43.sql .
ApplicationFormInstall.sql (File‐> Open) . OBS! Verify that ApplicationForm (Formulär) is not included in the solution: the installation script will delete all existing data. Run(F5) the script.
8. After the script has executed, check the result panel after red error messages. If error is
exposed check error message and decide whether to rollback your backup or continue. 9. If the module MediaArcive (MediaBank) is not included in the current solution, open the
script MediaArchive42Install.SQL (File‐> Open) . OBS! Make sure that the module
MediaArcive (MediaBank) does not exist: the installation script will delete all current data for this module. Run (F5) the script.
10. After the script has executed, check the result panel after red error messages. If error is
exposed check error message and decide whether to rollback your backup or continue. 11. If the module Relations (Relationer) is not included in the current solution, open the script
Relations42Install.SQL (File‐> Open). OBS! Make sure that the module Relations (Relationer) does not exist: the installation script will delete all current data for this module. Run (F5) the script.
12. After the script has executed, check the result panel after red error messages. If error is
exposed check error message and decide whether to rollback your backup or continue.
13. Open (File‐>Open) and run (F5) the script RelationsUpgradeFrom42CTo43.sql .
14. After the script has executed, check the result panel after red error messages. If error is
exposed check error message and decide whether to rollback your backup or continue. 15. If the module Newsletter (Utskick) is not included in the current solution, open the script
Newsletter42Install.sql (File‐> Open). OBS! Make sure that the module Newsletter (Utskick) does not exist: the installation script will delete all current data for this module. Run (F5) the script.
16. After the script has executed, check the result panel after red error messages. If error is exposed check error message and decide whether to rollback your backup or continue.
17. Open (File‐>Open) and run (F5) the script NewsletterUpgradeFrom42CTo43.sql .
18. After the script has executed, check the result panel after red error messages. If error is exposed check error message and decide whether to rollback your backup or continue. 19. If the module ProductCatalog (Produktkatalog) is not included in the current solution, open
the script ProductCatalog42Install.sql (File‐> Open). OBS! Make sure that the module ProductCatalog (Produktkatalog) does not exist: the installation script will delete all current data for this module. Run (F5) the script.
20. After the script has executed, check the result panel after red error messages. If error is exposed check error message and decide whether to rollback your backup or continue.
21. Open (File‐>Open) and run (F5) the script ProductCatalogUpgradeFrom425To43.sql .
22. After the script has executed, check the result panel after red error messages. If error is exposed check error message and decide whether to rollback your backup or continue.
Uppdatera filer i webbkatalogen
Some files in the web root are changed and need to be replaced at the server. OBS! Web.config and
all files in folder Templates, Modules/CMS/Panels and Modules/Newsletter/Templates will be
replaced. So create a backup of your web folder and compare the changed functionality when replacing the files.
All files are found in the compressed file Upgrade.zip.
1. Remove the following folders if they exists in the web root:
App_Code\CMS/PageTypes/FlashVideo
Events
Scripts
Modules\Circular\FCKEditor
Modules\CMS\FCKEditor
2. Remove the following folders if they exists in the web root:
bin\FredCK.FCKeditorV2.dll bin\Litium.Foundation.Modules.CMS.dll bin\Litium.Foundation.Modules.MediaArchive.dll bin\Litium.Foundation.Modules.Newsletter.dll bin\Litium.Foundation.Modules.Newsletter.HtmlEditor.dll bin\Litium.Foundation.Modules.ProductCatalog.dll bin\Litium.Foundation.Modules.Relations.dll Images\loginlogo.gif Modules\Circular\CircularCreate5.aspx Modules\Circular\CircularCreate5.aspx.cs Modules\CMS\PagesTasks.aspx
Modules\CMS\ PagesTasks.aspx.cs
Modules\CMS\SelectFile.aspx
Modules\CMS\ SelectFile.aspx.cs
Modules\ProductCatalog\Common\MediaArchiveDialog.ascx
Modules\ProductCatalog\Common\MediaArchiveDialog.ascx.cs
Modules\ProductCatalog\Common\SelectFile.aspx
Modules\ProductCatalog\Common\SelectFile.aspx.cs
3. Following templates have been changed. Control functionality if there is any customer
customization made. Templates\AdvancedSearch1.aspx Templates\ApplicationFormConfirmation1.aspx.cs Templates\Blog1.aspx Templates\Blog1.aspx.cs Templates\BlogPost1aspx Templates\BlogPost1.aspx.cs Templates\Error.aspx.cs
Templates\FileArchive1.aspx
Templates\FileArchive1.aspx.cs
Templates\FlashVideo1.aspx.cs
Templates\LoginPage1.aspx
Templates\LoginPage1.aspx.cs
Templates\MediaArchive1.aspx
Templates\MediaArchive1.aspx.cs
Templates\MyPage1.aspx
Templates\MyPage1.aspx.cs
Templates\NewsList_rss.aspx
