Differenze tra le versioni di "ItmSUITE® - SM/PM installation"
Da itm wiki.
(→DB: creation and initialization) |
|||
| Riga 1: | Riga 1: | ||
= 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 | ||
= Application server installation = | = Application server installation = | ||
Versione delle 14:25, 11 mag 2015
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
