Create Microsoft SQL Server Region and a Cross-Region Database Using Script Files

Attention: This feature is in Early Adopter Program (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.

Use these steps to create a region database, and if one does not already exist, a cross-region database. (This process also assumes that your enterprise server region is already correctly configured to run your application.)

To create a script file for a region database, on the command line, enter the following command:
```
dbfhadmin -script -type:region -provider:ss -name:<ES-name> -file:<script-name.sql> 
```
where <ES-name> is the name of the enterprise server region that will use the region database, and <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_region_<ES-name>_ss.sql.
To create a script file for a cross-region database, on the command line, enter the following command:
```
dbfhadmin -script -type:crossregion -provider:ss -file:<script-name.sql> 
```
Note: If you omit the -file option, the default name is create_crossregion_ss.sql.

Before you run the -createdb command, ensure that the sqlcmd command is on the PATH.
To create the region database, on the command line, enter the following command:
```
dbfhadmin -createdb -usedb:<instance> -provider:ss -type:region -name:<ES-name> -file:<script-name.sql> -user:<user> -password:<pass>
```
where <instance> is the SQL server instance name, and <user> and <pass> are valid logon credentials for the database. If -user and -password are not specified, SQL Server SSPI authentication is used - see your SQL Server documentation for more details.
To create the cross-region database, on the command line, enter the following command:
```
dbfhadmin -createdb -usedb:<instance> -provider:ss -type:crossregion -file:<script-name.sql> -user:<user> password:<pass> 
```
where <instance> is the SQL server instance name, and <user> and <pass> are valid logon credentials for the database. If -user and -password are not specified, SQL Server SSPI authentication is used - see your SQL Server documentation for more details.

Next, you must configure your enterprise server region to use the database(s).