|
|
|
|
|
|
|
|
|
|
- Overview
- Detailed characteristics of an HFSQL Client/Server database
- "General" tab
- "Connections" tab
- "Scheduled elements" tab
- "Backups" tab
- "Links" tab
- "Stored procedures" tab
- "Triggers" tab
- "Stored queries" tab
- "Parameters" tab
- "Locks" tab
- Ribbon options
Managing HFSQL Client/Server databases
 Disponible solo con este tipo de conexión
The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases. To display the characteristics of an HFSQL Client/Server database: - Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
- In the tree structure of the Control Center, expand the server and its databases.
- Double-click the name of the desired database.
- A new tab corresponding to the name of the selected database is displayed. A ribbon and different tabs are used to manage the characteristics of HFSQL Client/Server database.
Note From the Control Center pane, the database context menu allows you to: - Disconnect.
- Import an HFSQL Classic database.
- Start the data synchronisation.
- Duplicate the database.
- Delete database.
- Manage the rights on the database.
- Repair system tables.
Detailed characteristics of an HFSQL Client/Server database "General" tab This tab provides general information on database files: name, size, number of records. By default, only the names of the data files are displayed. The context menu of the files is used to: - Display the file details. The displayed information is calculated and updated for the file.
- Access the file. The file content is displayed in a new tab.
- Optimize and repair the file.
Note: The "Ocultar directorios de copias de seguridad" option displays only directories containing database data files.. When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Files" group, are used to: - Acceder al archivo: This option is used to open a new tab displaying the characteristics of the selected file.
- Ver detalles: This option is used to display the details of selected files in the database tab.
- Optimizar y reparar: This option displays the configuration window for optimizing and repairing HFSQL data files.
- Delete: This option deletes selected files..
"Connections" tab This tab lists the different users connected to the database. The list of active connections contains the following information: - the username,
- the computer name,
- the name of the application that accesses the database, etc.
From this tab, you can:  Novedad versión 2025Filter connections by machine, user and/or application. - Block connections: prohibit or authorize connections, using the "Block connections" option in the ribbon.
- Disconnect users.
Novedad versión 2025Simply select the user(s) to be disconnected from the list of connections, then use the "Desconectar usuarios seleccionados" option in the ribbon. - Send a message to the users.
Novedad versión 2025Simply select the recipient user(s) from the list of connections, then use the "Enviar un mensaje a los usuarios seleccionados" option in the ribbon.
The option "Don't display the connections of HFSQL Control Center (stated on this computer)" is used to only display the connections of users via the applications. "Scheduled elements" tab This tab is used to create, modify and delete schedule operations for the database: When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Scheduled elements" group, are used to: - create a new scheduling,
- display the details of a scheduling,
- run a scheduling,
- delete a scheduling.
"Backups" tab This tab is used to perform and restore database backups. This tab lists the database backups: When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Backups" group, are used to: - create a new backup (hot or scheduled backup),
- restart a backup,
- restore a backup,
- delete a backup.
"Links" tab This tab presents the information regarding the links between the data files found in the HFSQL Client/Server database. The following information is displayed: - Name of the link,
- Name of source file,
- Source cardinality,
- Name of destination file,
- Destination cardinalities,
- Integrity rule for deletion,
- Integrity rule for modification.
Note: Links are created and modified in the data model editor.. "Stored procedures" tab This tab lists the different sets of stored procedures and the stored procedures of current database. When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Stored procedures" group, are used to: - Update the sets of stored procedures.
- Delete a set of stored procedures.
"Triggers" tab This tab lists the different triggers of the current database. You can get: - The name of the trigger,
- The data files affected by the trigger,
- The stored procedure called when releasing the trigger,
- The HFSQL functions for releasing the trigger.
- The type of trigger (before/after)
The trigger can be enabled or disabled by clicking in the check box of the "Active" column. When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Triggers" group, are used to: - create a new trigger.
- modify a trigger.
- delete a trigger.
"Stored queries" tab This tab lists the different stored queries and the stored procedures of the current database. When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Stored queries" group, are used to delete a stored query. "Parameters" tab This tab lists the different paramters of the current database. The parameters are used to store: - The date and time of the last user connection,
- The environment parameters of an application,
- The status report of a stored procedure,
- etc.
For each paramteter, you have the ability to find out: - The parameter name,
- The parameter value.
When this tab is selected, additional options are displayed in the ribbon. These options, found in the "Parameters" group, are used to: - create a new parameter.
- modify a parameter.
- delete a parameter.
"Locks" tab This tab is used to manage the locks for all the data files of the current database. You can get: - the name of the file onto which the lock is applied,
- the number of the locked record,
- the name of the user who is locking,
- the name of the locking computer,
- the IP address of the locking computer,
- the name of the locking application,
- the type of lock,
- the lock start date,
- the lock duration.
This information can be retrieved through programming with HInfoLock. To unlock a record from the HFSQL Control Center, you must disconnect the user who locked the record. To disconnect users: - Display the database pane (double-click its name in the tree structure).
- Click the "Connections" tab.
- In the ribbon, in the "Connections" group, click "Disconnect users".
- In the window that is displayed, check the users to disconnect.
- Click "Disconnect the selected users".
For the selected HFSQL Client/Server database, the ribbon proposes the following actions: - In the "SQL query" group:
- New query: This option opens a special tab for querying the current database..
- Open a query: This option opens a specific tab corresponding to a previously performed query..
For more details, see Creating and executing a query. - In the "Databases" group:
- Import an HFSQL Classic database.
- Copy files from the server.
- Synchronizing the database.
- Duplicate database.
- Close connection to the database.
- In the "Rights" group, the option "Management of rights" allows you to manage the rights granted to the users and to the groups on the database.
- In the "Files" group, the "Optimize and repair" option is used to optimize one or more data files. For more details, see Optimizing and repairing data files.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|