PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • When do I have to create a SCM database?
  • Converting an existing SCM database from HFSQL Classic to HFSQL Client/Server
  • Backups
  • Changing the administrator password (SCM database in Client/Server mode)
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
To share a project via the Source Code Manager, an SCM database must be created. This SCM database must be created once only on a server.
The operating system and the file system on which the SCM database is installed must support files exceeding 4 GB.
The SCM database can be created:
  • on a HFSQL Client/Server server (recommended solution): the SCM database will be in HFSQL Client/Server format. In this case, you must specify:
    • the server,
    • the database,
    • the port used,
    • the name and password of an administrator of HFSQL database.
      The HFSQL Client/Server server that is hosting the database can be found on a local network, on a remote network or on a development platform of PCSCLOUD.
  • in a shared directory on the network: all the SCM users must have full rights on this directory. The SCM database will be in HFSQL Classic format.
    To do so, specify the network directory where the SCM database will be created.
In both cases (HFSQL Client/Server format or HFSQL Classic format), the computer must be reliable and secure. See HFSQL Client/Server database: Recommendations about security for more details
Note: From version 19, HFSQL is the new name of HyperFileSQL.
When do I have to create a SCM database?
The SCM database must be created once only.
WINDEV, WEBDEV and WINDEV Mobile allow you to create this SCM database:
Once the SCM database is created, all the shared WINDEV, WEBDEV and WINDEV Mobile projects can be imported into this SCM database.
Converting an existing SCM database from HFSQL Classic to HFSQL Client/Server
The following operations allow you to convert an existing SCM database from HFSQL Classic to HFSQL Client/Server:
  1. Optimize the format of the HFSQL Classic database of SCM. To do so, open the SCM administrator ("SCM .. SCM administrator") and select "Tools .. Maintenance .. Migrate the database to the most recent format".Optimize the format of the HFSQL Classic database of SCM. To do so:
    • open the SCM administrator: on the "SCM" pane, in the "Database" group, expand "Manage" and select "SCM administrator".
    • in the administrator, select "Tools .. Maintenance .. Migrate the database to the most recent format".in the administrator, on the "Tools" pane, in the "Maintenance" group, select "Migrate to most recent format"
  2. Install (if necessary) a HFSQL server on the computer where the HFSQL Client/Server database of SCM must be installed.
  3. In the SCM administrator, select "Tools .. Maintenance .. Convert the database to Client/Server".In the SCM administrator, on the "Tools" pane, in the "Maintenance" group, select "Switch to Client/Server".
  4. All the users can connect to the HFSQL Client/Server database of SCM by passing the necessary parameters (server, database, port used, name and password of an administrator of HFSQL database).
Backups
We advise you to perform backups of the SCM database on a regular basis. To do so, all you have to do is copy and archive the data files corresponding to the SCM.
This operation will be automatically performed in a forthcoming version.
Changing the administrator password (SCM database in Client/Server mode)
Changing the password of the SCM administrator, in a Client/Server database, must be done from the HFSQL Control Center of the database of SCM.
You must:
  1. Select the server corresponding to the database of SCM.
  2. Select the "Users" tab.
  3. Select the administrator in the list of users and click "Edit".
  4. Modify the password and validate.
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment