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