OpenFMS Database Setup

How to set up OpenFMS for my event?

To set up OpenFMS is rather easy but time consuming for the first time you run the program.

1. Download the release of OpenFMS from the Release page.
2. Install SQL Server 2017 and set up a local server called MY-PC.
3. Install SQL Management Studio and connect to the MY-PC server you created.
4. Create a new SQL database called OpenFMS.
5. Create a new table called: teaminfo. The rows are configured like this:
6. Create a table called: matches. The rows are configured like this:
7. Now your done, leave open SQL Management Studio when using OpenFMS since it keeps the SQL Server Service running, Windows 10 likes to stop SQL Services for some reason with OpenFMS.