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
  1. Open a command window in BE_HOME/bin and run the yourname.sql script. (for example, @acme.sql). Use the user BE_USER, password BE_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
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.