The following section includes the information on the manual installation of Odin or MWS manually on an MS SQL Server database.
Database Schema
The subdirectory Admin\MS-SQL contains the following files. They are used to create the Odin and MWS schemes.
- MSSql_Odin5.sql
- MSSql_MWS.sql
Notes
- Run both scripts using an account which is a member of the composer_full role.
- You may have to create SQL Server databases to run the scripts.
- You can provide any relevant name to the databases. You require the names of these databases at a later step in the configuration process.
Database User
To create the required database roles and users, complete the steps in Create the database roles and users in SQL Server.