Step 2 Run the Project Schema Script (as BE_USER)
In this step, you log on as the user you created and run a script to create the project related part of the database schema.
- Procedure
- Open a command window in
BE_HOME/bin and run the
yourname.sql
script. (for example,@acme.sql
). Use the userBE_USER
, passwordBE_USER (
or whatever username and password you have set up).Following are the sample commands for running project schema scripts for you backing store. For complete details on these commands, such as to enable SSL aunthentication or enable client-side and server-side encryption, see documentation of your backing store.
- For Oracle:
sqlplus BE_USER/BE_USER @ yourname.sql
- For SQL Server:
osql -S Your-Server –d Your-DB -U BE_USER -P BE_USER -n -i @yourname.sql
- For MySQL:
mysql -u BE_USER -p database_name < yourname.sql
- For Postgresql:
psql -U username -d database_name -f yourname.sql
For ActiveSpaces:
tibdg -g <grid_name> -r <FTL_realm_URL> -s <yourname>.tibdg
For Cassandra:
cqlsh -k <keyspaceName> -u <username> -p <pwd> -f <yourname>.cql
- For Oracle:
Result
If there are no errors, your database tables are now configured for use. If there are errors you may need to add some mappings to the key word mapping file.