Step 3: Run SQL scripts

Run the SQL scripts in the table below.

Note: These scripts require administrator permissions on the server to run them.

CAUTION:

If you have a different port or different password, make sure that you change the password and port numbers in these examples to match the ones in your configuration.

Run these scripts from the sqlcmd utility window or from Microsoft SQL Server Management Studio.

Action	SQL Script
Create Quartz	-i <filepath to DDL>/create_quartz_sqlServer.sql
Create Hibernate repository	-i <filepath to DDL>/create_repository_sqlServer.sql
Create Jackrabbit	-i <filepath to DDL>/create_jcr_sqlServer.sql
Create Pentaho Operations mart	-i <filepath to DDL>/pentaho_mart_sqlserver.sql

Note: You unpacked the Pentaho Operations mart SQL file while preparing your environment for the archive installation process. Depending on your environment, see Prepare your Windows environment for an archive install or Prepare your Linux environment for an archive install for details.