Differenze tra le versioni di "ItmSUITE® - SM/PM installation"
(→DB: creation and initialization) |
(→DB: creation and initialization) |
||
| Riga 7: | Riga 7: | ||
2. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open <u>'''Config/Scripts/Create_MSSQL.sql'''</u> script, select ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' database and run the script. | 2. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open <u>'''Config/Scripts/Create_MSSQL.sql'''</u> script, select ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' database and run the script. | ||
| − | 3. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open <u>'''Config/Scripts/Recreate_PSM_views.sql'''</u> script, select SM/PM database and run the script (ignore the error messages related to failed attempt to delete not present views). | + | 3. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open <u>'''Config/Scripts/Recreate_PSM_views.sql'''</u> script, select ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' database and run the script (ignore the error messages related to failed attempt to delete not present views). |
| − | 4. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open '''<u>Config/Scripts/Create_MSSQL.sql</u>''' script, remove part of script about table creation (from beginning to 'alter table') and select SM/PM database, Run the script. | + | 4. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open '''<u>Config/Scripts/Create_MSSQL.sql</u>''' script, remove part of script about table creation (from beginning to 'alter table') and select ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' database, Run the script. |
| − | 5. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open '''<u>Config/Scripts/Init_MSSQL.sql </u>''' script, select SM/PM database and run the script. | + | 5. From ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' installation package open '''<u>Config/Scripts/Init_MSSQL.sql </u>''' script, select ''[[Glossary|SM]]'' / ''[[Glossary|PM]]'' database and run the script. |
= Application server installation = | = Application server installation = | ||
Versione delle 14:36, 11 mag 2015
DB: creation and initialization
Please perform the following steps:
1. Create new SM / PM database (use a DB role with grants to perform this).
2. From SM / PM installation package open Config/Scripts/Create_MSSQL.sql script, select SM / PM database and run the script.
3. From SM / PM installation package open Config/Scripts/Recreate_PSM_views.sql script, select SM / PM database and run the script (ignore the error messages related to failed attempt to delete not present views).
4. From SM / PM installation package open Config/Scripts/Create_MSSQL.sql script, remove part of script about table creation (from beginning to 'alter table') and select SM / PM database, Run the script.
5. From SM / PM installation package open Config/Scripts/Init_MSSQL.sql script, select SM / PM database and run the script.
