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> [-db|existdb:<database-name>] [-file:<script-name.sql>]

where <es-name> is the name of the enterprise server region that will use the region database; <database-name> is the name of a new database (-db) or existing database (-existdb) that can house multiple datastores\regions, and a cross-region database - if you omit either option, a new database called <es-name> will be created for the region database.

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 [-db|existdb:<database-name>] [-file:<script-name.sql>]
```
where <database-name> is the name of a new database (-db) or existing database (-existdb) that can house multiple datastores\regions, and a cross-region database - if you omit either option, a new database called _$XREGN$ will be created for the cross-region database

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 <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: tcp: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.

Now that the region and cross-region databases have been created, you can configure the database configuration file to use them.