ItmSUITE® - SM/PM installation

DB: creation and initialization

Please perform the following steps: 1. Create new itmSUITE database (use a DB role with grants to perform this). 2. From itmSUITE installation package open Config/Scripts/Create_MSSQL.sql script, select itmSUITE database and run the Script. 3. From itmSUITE installation package open Config/Scripts/Recreate_PSM_views.sql script, select itmSUITE database and run the Script (ignore the error messages related to failed attempt to delete not present views). 4. From itmSUITE installation package open Config/Scripts/Create_MSSQL.sql script, remove part of script about table creation (from beginning to 'alter table') and select itmSUITE Database, Run the Script 5. From itmSUITE installation package open Config/Scripts/Init_MSSQL.sql script, select itmSUITE database and run the Script