MSSQL

MSSQL is a suite of database software published by Microsoft. It includes a relational database engine, which stores data in tables, columns and rows.

Update database version

Open SQL Server Management Studio or Azure Data Studio and connect to localhost with the following credentials.

Username

sa

Password

yourStrong(!)Password
Run the following SQL statement against the Open World Server database.
```
SELECT * FROM OWSVersion
```
Compare the OWSDBVersion returned with the SQL update scripts in the Databases\MSSQL\UpdateScriptsFolder to see which scripts to run on your database.
The update scripts have From[SomeVersion]To[SomeVersion] in the name. Run them in order starting with the From[SomeVersion] that matches your OWSDBVersion from the previous step. To run the script open the file, copy the contents from it and run it as a SQL statement against the Open World Server database like you did in step 2. If you are not familiar with SQL please refer to the SQL Tutorial to learn more about it.

Create API Key

Open SQL Server Management Studio or Azure Data Studio and connect to localhost with the following credentials.

Username

sa

Password

yourStrong(!)Password
Run the following SQL statment against the Open World Server database.

(Optional): A specific GUID can be entered as an optional final parameter, after password, in the format of ‘00000000-0000-0000-0000-000000000000’.
```
EXEC [dbo].[AddNewCustomer] 'CustomerName', 'FirstName', 'LastName', 'Email', 'Password'
```
Be sure to replace the values:

CustomerName

The nickname or profile name of the customer.

FirstName

The firstname of the customer.

LastName

The lastname of the customer.

Email

Enter the mail address of the customer.

Password

Enter a secure password.
Run the following SQL statment against the Open World Server database to get your API key. Save the key for later.
```
SELECT TOP 1 CustomerGUID FROM Customers
```

Next: OWS Starter Project