| Product(s): | Promis.e CONNECT | ||
| Version(s): | 10.00.XX.XX to 23.01.00.XX | ||
| Environment: | N/A | ||
| Area: | Installation Configuration | ||
| Subarea: | Installation Error |
Background:
This KB article will help the users who are planning to start using Azure SQL Database with Promis.e CONNECT versions.
Note:
1. This article is for users who are planning to use Azure SQL Database and not for users who are planning to use SQL Database on Azure VM.
2. This article is for creating new blank project database for New Project to be created or for restoring Backup of database.
Steps to be followed:
- Create a Blank database in Azure SQL Server. You can refer to the below link on how to create Database.
https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&tabs=azure-portal - Next open SQL Server Management Studio and connect to the Azure SQL Server.
- Select the script by File >> Open >> File >> Browse to "C:\Program Files\Bentley\Promise 2023\Promise\Electrical\SqlScripts" >> select SqlServerProject.sql >> Open.
Note: If you Promis.e CE 2023 / 2023 U1 use the below script from download link and skip next to steps to step 6.
https://bentleysystems.service-now.com/community?id=community_document&sys_id=9d8bc9f747024a5888c56642846d43c6 - In the query dialog select and delete all the script before the "Create Project Table" line as highlighted in below screen shot.
- Change the "$ShortProductName$" text to "promis.e" (do not include the double quotes).
- Next find the "end" using Find for searching it until you reach one above the query "Create Unique Index ..." or go to line number 1382. Select the "end" and delete it as seen in below screen shot.
- Make sure the Active Database is set to Database create in Step 1 to be used for Project Database. Then select "Execute" to run the query.
Original Author: Satish Saptasagar