ItmSUITE® - SM/PM installation
Da itm wiki.
Versione del 11 mag 2015 alle 14:25 di Renato.daverio (discussione | contributi) (→DB: creation and initialization)
DB: creation and initialization
Please perform the following steps:
- Create new itmSUITE database (use a DB role with grants to perform this).
- From itmSUITE installation package open Config/Scripts/Create_MSSQL.sql script, select itmSUITE database and run the Script.
- 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).
- 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
- From itmSUITE installation package open “Config/Scripts/Init_MSSQL.sql” script, select itmSUITE database and run the Script
