Tuto WINDEV 25

352 Part 5: Managing a HFSQL Client/Server database Overview Now that we know how to create and/or adapt an application so that it operates in HFSQL Client/ Server, let’s see how to manage the associated database. Indeed, a Client/Server database requires: • a specific configuration of computers (setup of a HFSQL server, ...). • a management performed via the HFSQL Control Center. Configuring the computers To use a HFSQL Client/Server database, a HFSQL server must be installed on the server. Several HFSQL servers that use different ports can be installed on the same computer. One or more databases can be installed on each server. For example, a test HFSQL server that includes a test database and a production HFSQL server that is using a different port can be installed on the same computer. The HFSQL Control Center The HFSQL Control Center is used to perform all management operations on the HFSQL Client/ Server servers and databases. We are going to present the most important features. First of all, we are going to start the HFSQL Control Center from the WINDEV project. ▶ To start the HFSQL Control Center and to access data: 1.  In the WINDEV menu, on the "Tools" pane, in the "Database" group, click "HFSQL". The HFSQL Control Center is displayed. 2.  The home window of HFSQL Control Center is displayed. The analysis of current project is automatically selected. 3. Validate the screen. The HFSQL Control Center is displayed. This mode allows you to see the different files linked to the analysis of the current project.