Deploying an existing HFSQL database in PCSCloud

The CLOUD for PC SOFT applications allows you to use the HFSQL Server to share databases anywhere in the world, from any application (iOS, Android, Site, Desktop, etc.).


Simply create a PCSCloud operating platform  and enable the HFSQL Server role.

To configure the roles of the platform: see the guide Configuring the roles.


You can then create new databases on the HFSQL Server of the platform and also deploy one or more existing HFSQL databases on it.


Let's see in this guide how to deploy an existing HFSQL database on the HFSQL server of the platform.


Steps 


  • Enable HFSQL remote access if necessary ("Remote access" widget).

Write:

    • the address of your platform (at the top, in the "Access your platform" section)
    • the user name and password of the HFSQL server (at the bottom, in "Management of HFSQL server").

These parameters will allow you to connect to the HFSQL server of the platform from the HFSQL Control Center.


But right now, where is the data that you want to import onto the platform ?

If it is a Client/Server database, from the HFSQL Control Center, perform a backup of this database on your computer, locally.  

This allows you to get the FIC, NDX, FTX and MMO files.


  • Still in the HFSQL Control Center, log in to the HFSQL server of the platform. To do so, enter the address of the platform, the user name and the password that you wrote down.

Right click the server icon, in the top left corner of the window of HFSQL Control Center.

Click "Import a Classic database".

Select the directory where the data files are located: the backup directory if your database is in Client/Server mode, and the usual directory of the database otherwise.


Once the import is performed, your database can be immediately accessed from the Cloud platform.