New article
Recently updated
Creating the Database on Microsoft SQL and Oracle for 8.0.0
Who is this article for?IT Personnel performing the installation of Please Review.
IT Access is required.
This article outlines the steps to create and populate the Please Review database on both Microsoft SQL Server and in Oracle. This article is split into the following sections:
Note: This article is part of a series covering the Please Review installation process. Please visit Performing a Please Review 8.0.0 Installation to view the rest of the process.
1. How to Create the Database in Microsoft SQL Server
1. Creating the Database
- Launch Microsoft SQL Management Studio and connect to the server.
- Right click on Databases and select New Database.
- Name the database "Please Review".
Important Notes:
- This database must be created using a case-insensitive sort order (i.e. the sort order will have the letters _CI_ in the title).
- The user should be configured to use SQL server authentication rather than integrated Windows
authentication (SSPI).
- Click OK.
2. Creating the Database User
- Navigate to Security under the server, not under the database. Right-click and choose New Login.
- Complete the Login name field, select SQL Server authentication, and input the password twice.
- Ensure to uncheck User must change password at next login and consider unchecking Enforce password expiration to avoid frequent updates to the Please Review config file and restarting Please Review.
- On the User Mapping page, select the Please Review database, and specify a Username for the database. This database username will be established and linked to the server login name created in this process. You can use the same name as the login name. Set dbo as the default schema. With the Please Review line selected, check the db_owner entry at the bottom.
3. Creating the Database Schema
- Launch SQL Server Management Studio and click the Connect button, then select the Database Engine option.
- Choose SQL Server Authentication and provide the login username and password you established for this purpose.
- If you have multiple connections to the database server, ensure you remain connected as the Please Review user. Right-click on any connections not associated with Please Review and select the disconnect option.
- Locate the installation files and navigate to runtime/config/createdb/.
- Rename createdb.mssql.txt to createdb.mssql.sql.
- Open the renamed file in SQL Server. Confirm that the user displayed in the query tab is Please Review, and ensure the appropriate database is selected from the dropdown list of tables for the query.
- Click Execute to run the script against the Please Review database.
2. How to Create the Database in Oracle
- Create a database (or schema in Oracle terms) to store Please Review data.
- While a separate Oracle instance (database) for Please Review isn't mandatory, it's recommended to create a separate user (schema) named Please Review.
- Allocate a tablespace or a group of tablespaces to contain Please Review tables, indexes, and stored procedures.
- Ensure that the user has the required privileges to create tables, indexes, and stored procedures.
- Execute the script as instructed below:
sqlplus <user>/<password> < createdb.oracle.txt
Note: You must connect as the database user you created above. If sqlplus.exe is not on the path you
will need to supply the full path to this.
Tip: If you have everything in place you are ready to proceed. Please see Configuring Please Review 8.0.0 in IIS for the next steps or Performing a Please Review 8.0.0 Installation to review the entire process.