Create Microsoft SQL Server Region and a Cross-Region Database 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 script file for a region database, on the command line, enter the following command:
```
dbfhadmin -script -type:region -provider:ss -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; <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 [-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_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.

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