Create Datastore Scripts for Azure

Attention: This feature is in Early Adopter Product (EAP) release status. We will continue the development of additional features and provide additional interfaces via patch updates and future releases. Please contact Micro Focus SupportLine if you require further clarification.

You can choose to have databases created dynamically like SQL Server and PostgreSQL, but because Azure SQL database creation can be very slow, we recommended that you create them ahead of time using SQL scripts.

To create the database script file, on the command line, enter the following command:

dbfhadmin -script -type:datastore -provider:az -name:<datastore-name> -file:<script-name.sql>

where <script-name.sql> is the name of the script file to be created.

Note: If you omit the -file option, the default name is create_dstore_<datastore-name>_az.sql.

By default, this script creates a database with the following characteristics:

Parameter	Value
EDITION	standard
MAXSIZE	1GB
SERVICE_OBJECTIVE	S0

If you require the database to be created with different characteristics, you must edit the script directly.

Create further script files for any more required datastores.
Once you have created the script files, use the dbfhadmin utility to run them, and create the required databases. Before you run the -createdb command, ensure that the sqlcmd command is on the PATH.
To create the database, on the command line, enter the following command:
```
dbfhadmin -createdb tcp:<database-address> -provider:az -type:datastore -file:<script-name.sql> -userid=<user> -password=<pass>
```
where <database-address> is the fully qualified database and server name (for example: mydbinst.database.windows.net), <script-name.sql> is the name of the script file that was created in an earlier step, and <user> and <pass> are valid logon credentials for the database.

Next, you must create or edit a configuration file, so that it contains entries to the datastore databases.