Thank you for using the English version of the JTL-Guide!
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
We are currently still building up the English documentation; not all sections have been translated yet. Please note that there may still be German screenshots or links to German pages even on pages that have already been translated. This guide mostly addresses English speaking users in Germany.
Executing SQL on the database
Your task/initial situation
You want to execute an SQL command for your JTL-Wawi database. In the following paragraphs, we will explain how to download and set up the programs Microsoft SQL Server Management Studio and Heidi SQL. Afterwards you will be able to issue SQL commands and saved procedures (which have been provided to you by our support team via the JTL-Forum, for example).
SQL Server Management Studio
- Download the SQL Server Management Studio: Go to the Microsoft website: Download Management Studio
- Look up the name of the server in the Datenbankverwaltung (Database administration).
- Start the SQL Server Management Studio. Enter the SQL server under Server name and then click Connect.
- After you have logged in, open the Databases directory in the Object Explorer on the left. Select the eazybusiness entry and then click New Query.
- The editor opens. Enter an SQL command. Then click on Execute at the top of the screen.
Attention: Important technical note! If you want to execute the query for several tenants, repeat the steps starting from Step 4 and select the respective tenant database instead of the eazybusiness database.
Heidi SQL
- Download the Heidi Installer and install the tool: Heid SQL Website: Download tool
- Look up the name of the server in the Datenbankverwaltung (Database administration).
- Start Heidi SQL and click Neu (New). Adjust the following settings on the right-hand side:
- Click Öffnen (Open).
- Select the “eazybusiness” database. Then click Abfrage (Query) and enter the desired SQL query into the editor. Then click on the arrow to run the query (see screenshot).
Attention: Important technical note! If you want to execute the query for several tenants, repeat the steps starting from Step 4 and select the respective tenant database instead of the eazybusiness database.