Page Comparison

...

1. Create a database for TermWeb to store data in (e.g. termweb). 
   
   • Open pgAdmin and right click on Databases and select New Database
     Encoding: UTF8
     Template: template0
     Collation: C
     Character Type: C
     
     
2. Create a database login role (user) which TermWeb will connect as (e.g. termwebuser), with permissions for the database.
   • Create a new login role (right click on Login Roles and select New Login Role) and name it termwebuser. Select password: termwebuser.
   • Set login role as database owner and set permissions (right click on termweb database and select Properties). Select termwebuser as owner.
     
     
3. Execute the termweb_postgresql.sql file from the installation package to create the database tables.
   • Select termweb database and click on SQL icon to open an SQL execution window.
   • In SQL Server Management Studio, navigate to File > Open > File and select the file.
   • Right-click and select Execute, or just press F5 to run the scriptCopy paste termweb_postgresql.sql and execute query.

2. Copy the SQL Server JDBC Driver to Tomcat

...