Differenze tra le versioni di "ItmSUITE® - SM/PM installation"
(→DB: creation and initialization) |
(→DB: creation and initialization) |
||
Riga 3: | Riga 3: | ||
Please perform the following steps: | Please perform the following steps: | ||
1. Create new itmSUITE database (use a DB role with grants to perform this). | 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 | + | |
− | 3. From itmSUITE installation package open Config/Scripts/Recreate_PSM_views.sql script, select itmSUITE database and run the | + | 2. From itmSUITE installation package open Config/Scripts/Create_MSSQL.sql script, select itmSUITE database and run the script. |
− | 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 | + | |
− | 5. From itmSUITE installation package open Config/Scripts/Init_MSSQL.sql script, select itmSUITE database and run the | + | 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. | ||
= Application server installation = | = Application server installation = |
Versione delle 14:27, 11 mag 2015
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.