StuertzCloud - Creating Local SQL Database

How to create a SQL Database instance on the local network to enable factory machines to communicate with StuertzCloud

Difficulté

Hard Difficile

Durée

30 minute(s) minute(s)

Introduction

See StuertzCloud - Setup Overview for an overview of the setup.

This tutorial covers the setup of the Local SQL Express database instance and creating a "ProOpt" database structure on it.

• This database installed on the 'Location' local network.
• The 'Machines' write their production data to it
• The 'Gateway' software uploads this data to the StuertzCloud server

See Also

StuertzCloud - Installing Gateway

StuertzCloud - Setting up Stuga Machine to Write Production Data

StuertzCloud - Creating a Customer Location

...You must have SQL Server Management Studio (SSMS) installed to manage the databases

Étape 1 - Download and Install SQL Server Express 2022

👉 Download SQL Server Express 2022

• Run the Installer: Locate the downloaded file named SQL2022-SSEI-Expr.exe and double-click it to launch the installer.Microsoft+5Microsoft+5Microsoft+5
• Choose Installation Type: In the installer window, select the Basic installation option. This will install SQL Server Express with default settings.
• Accept License Terms: Read and accept the license terms to proceed with the installation.
• Installation Progress: The installer will download and install the necessary components. This process may take several minutes.
• Installation Complete: Once the installation is complete, you'll see a confirmation screen. You can note the instance name (usually SQLEXPRESS) for future reference.

Étape 2 - Verify Installation

After installation, you can verify that SQL Server Express is running by:

• Opening SQL Server Management Studio (SSMS).
• Connecting to the server using the instance name (e.g., .\SQLEXPRESS).
• Ensuring that the connection is successful and that you can see the server objects.

Étape 3 - Download the ProOpt sql schema

This is stored on the Software versions Monday Board

Étape 4 - Open SQL Server Management Studio (SSMS)

Launch SSMS and connect to your local server. If you used default settings, the server name will be:

.\SQLEXPRESS

Use “Windows Authentication” unless you specifically created an SQL login.

Étape 5 - Open the SQL Script

• Go to File > Open > File…
• Browse to and open the script file: ProOpt-StuertzCloud-Reference-Database-20240131 (4).sql

Étape 6 -

en none 0 Draft