Create Azure Region and Cross-Region Databases Using Script Files

If a database does not exist at the point that it is required, it is created on-the-fly; this can be slow for certain RDBMS types, and so we recommended that you create any required databases ahead of time, using SQL scripts.

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> -user:<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> -user:<user> -password:<pass>

see previous command for descriptions.

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