Create Region and Cross-Region 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.

For Azure SQL databases, you can use the conventional method of database creation, using ODBC DSNs, as detailed for the other supported database types; but due to the Azure architecture, it is preferable to create the databases ahead of time, using an SQL script file.

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

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

where <es-name> is the name of the intended enterprise server region.

Note: If you omit the -file option, the default name is create_region_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.

To create a cross-region database script file, on the command line, enter the following command:
```
dbfhadmin -script -type:crossregion -provider:az -file:<script-name.sql>
```
Note: If you omit the -file option, the default name is create_crossregion_az.sql.
Once you have created the script files, use the dbfhadmin utility to run them, and create the required databases.
To create a region database, on the command line, enter the following command:
```
dbfhadmin -createdb tcp:<database-address> -file:<script-name.sql> -type:region -provider:az -name:<ES-name> -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, <ES-name> is the name of the enterprise server region to operate as the region database, and <user> and <pass> are valid logon credentials for the database.

To create the cross-region database, on the command line, enter the following command:

dbfhadmin -createdb tcp:<database-address> -provider:az -type:crossregion -file:<script-name.sql> -userid=<user> -password=<pass>

see previous command for descriptions.

Next, you must create or edit a configuration file, so that it contains entries to the region and the cross-region databases.