Page Comparison

...

Platform

Create the database user

Oracle:

This command will prompt for the name of the user to be created.

Code Block
sqlplus SYS/SYSPassword@SID as SYSDBA @schema/oracle/install/create_user

Sql Server:

Before creating the database, ensure that default collation is Latin1_General_CI_AS

Code Block

SELECT SERVERPROPERTY('collation');

SELECT DATABASEPROPERTYEX('phixflow', 'Collation');

USE master;  
GO  
IF DB_ID (N'MyOptionsTest') IS NOT NULL  
DROP DATABASE MyOptionsTest;  
GO  
CREATE DATABASE MyOptionsTest  
COLLATE Latin1_General_100_CS_AS_SC;  
GO  
  
--Verify the collation setting.  
SELECT name, collation_name  
FROM sys.databases  
WHERE name = N'MyOptionsTest';  
GO

This command requires the user, the password, the login and the database to be provided as parameters.

Code Block
sqlcmd -S localhost\myservice -i schema/sql_server/install/create_database_and_user.sql -v dbName="phixflow" dbLogin="phixflow" dbUser="phixflow" dbPassword="mypass"

MariaDB:

Anchor

	mariaDBexampleDBcreateCommand
	mariaDBexampleDBcreateCommand

Connect to the database as root (or an administrator):

Code Block
mysql --user=<myrootuser> --password

Create the user, supplying the name of the database, the user and the password in the commands below:

Code Block
create database phixflow CHARACTER SET = 'utf8' COLLATE = 'utf8_bin'; grant all privileges on phixflow.* to '<myuser>'@'%' identified by '<mypass>'; exit

...

Code Block
java -jar bin/installer.jar -url="jdbc:oracle:thin:@hostname:1521/phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name"

SQL Server:

Note
See notes above - make sure before you install PhixFlow that the database has the required collation

Code Block
java -jar bin/installer.jar -url="jdbc:sqlserver://myhost\myserver;databaseName=phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name"

...

Versions Compared

Old Version 13

New Version 14

Key