Solaris clustered server: Creating database schemas and users
To create database schemas and users, you can create a copy of the template SQL scripts and edit this copy to manually create the database schemas and users. The template SQL scripts should be used as a guide for creating executable scripts and contain invalid SQL syntax.
Before you begin
- You should have completed installing SQL Server and creating databases.
- If WebSphere® Portal Version 8.0 and an earlier version of WebSphere Portal coexist, the database user IDs for WebSphere Portal Version 8.0 must be different than earlier versions to avoid conflicts during installation.
About this task
At least one user is required for each SQL Server instance. Take care to create users in an environment that has the same settings as the actual runtime environment. For example, avoid creating a user in an English environment if you plan to use that user in a Turkish environment.
Refer to the following locations to refer to the SQL script templates:
| Database domain | Location of template |
|---|---|
| Release | PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/release/createSchema.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/release/createRuntimeUsers.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/release/createUsers.sql |
| Community | PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/community/createSchema.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/community/createRuntimeUsers.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/community/createUsers.sql |
| Customization | PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/customization/createSchema.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/customization/createRuntimeUsers.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/customization/createUsers.sql |
| JCR | PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/jcr/createSchema.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/jcr/createRuntimeUsers.sql PortalServer_root/base/wp.db.impl/config/templates/setupdb/sqlserver2005/jcr/createUsers.sql |
| Feedback | PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/feedback/createSchema.sql PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/feedback/createRuntimeUsers.sql PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/feedback/createUsers.sql |
| Likeminds | PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/likeminds/createSchema.sql PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/likeminds/createRuntimeUsers.sql PortalServer_root/pzn/prereq.pzn/config/templates/setupdb/sqlserver2005/likeminds/createUsers.sql |