Run the Project Schema Script (as BE_USER)

In this step, you log in as the user you created and run a script to create the project related part of the database schema.

Procedure
1. Open the command prompt and navigate to theBE_HOME/bin directory (the default location of the scripts).
2. Run the yourname.sql script. (For example, @acme.sql). You can log in with the username BE_USER, password BE_USER or whatever username and password you have set up).
3. On the command prompt, type the appropriate command for running project schema scripts for your backing store. For complete details on these commands, such as to enable SSL authentication or enable client-side and server-side encryption, see the 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