Configuring Microsoft SQL Server
Perform the following steps to configure Microsoft SQL Server.
Admin Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/admin/bin/sqlserver_admin_db.properties
file in a suitable editor and update the values. -
Run the following scripts from the
$OM_HOME/db/dbscripts/sqlServer/admin/bin
directory:db-setup.sh
seed_common_authConfig_db_setup.sh
Archival Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/archival/bin/sqlserver_archival_db.properties
file in a suitable editor and update the values. -
Run the following script from the
$OM_HOME/db/dbscripts/sqlServer/archival/bin
directory:db-setup.sh
Catalog Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/catalog/bin/sqlserver_catalog_db.properties
file in a suitable editor and update the values. -
Run the following script from the
$OM_HOME/db/dbscripts/sqlServer/catalog/bin
directory:db-setup.sh
Jeopardy Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/jeopardy/bin/sqlserver_jeopardy_db.properties
file in a suitable editor and update the values. -
Run the following script from the
$OM_HOME/db/dbscripts/sqlServer/jeopardy/bin
directory:db-setup.sh
Order Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/order/bin/sqlserver_order_db.properties
file in a suitable editor and update the values. -
Run the following script from the
$OM_HOME/db/dbscripts/sqlServer/order/bin
directory:db-setup.sh
User Database
- Procedure
-
Open the
$OM_HOME/db/dbscripts/sqlServer/user/bin/sqlserver_user_db.properties
file in a suitable editor and update the values. -
Run the following script from the
$OM_HOME/db/dbscripts/sqlServer/user/bin
directory:db-setup.sh
Provide the SQL Server details in each of the configuration files. For more details, see the $OM_HOME/samples/sqlServer-sample-property/sample_sqlServer_properties.properties
file.