Populating the database manually

Generally, the database population is performed automatically by Portofino when you run the installer. 
In some cases, e.g., if you want to grant special permissions on the various schemas/tables/views, you can:

• Create the database as discussed here.
• Ignore the automatic installer.
• Follow the manual procedure described below.

In the binary distribution, locate the directory called 'sql'. It should contain six mdtemplate scripts:
mdtemplate-db2v9-3.1.x.sql 
mdtemplate-derby10-3.1.x.sql 
mdtemplate-mysql5-3.1.x.sql 
mdtemplate-oracle9-3.1.x.sql 
mdtemplate-postgresql8-3.1.x.sql 
mdtemplate-sqlserver2005-3.1.x.sql 

Pick the one that is suitable for your database product. If you have any special requirements, you can edit the file in a text editor. To run the script use the following database-specific instructions. 


To avoid problems at a later stage, make sure you set your database to use a character encoding that is suitable for your language. UTF-8 is a popular safe choice. Please notice that 8-bit ASCII is generally a poor choice and should be avoided. 

Oracle

Run the following command:
sqlplus username/password @mdtemplate-oracle9-3.1.x.sql

Microsoft SQL Server

Run the following command:
osql.exe -U username -P password -d portofinodb -i mdtemplate-sqlserver2005-3.1.x.sql

IBM DB2

Run the following command:
db2 -s -f mdtemplate-db2v9-3.1.x.sql

PostgreSQL

Run the following command:
psql -f mdtemplate-postgresql8-3.1.x.sql portofinodb username 

MySQL

Run the following command:

Apache Derby

To access the database, launch the ij application. Then run the following commands.
 

connect 'jdbc:derby:/tmp/portofinodb;create=true'; 
run 'mdtemplate-derby10-3.1.x.sql'; 
exit; 

If you prefer to use a graphical front-end with Derby, we recommend SQuirreL SQL Client.

---

Previous: Running multiple instances 

Next: Upgrading from an older version