Deploying an existing HFSQL (HyperFileSQL) database in PCSCloud

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


All you have to do is create a PCSCloud operating platform and activate the HFSQL Server role.

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


Then, you have the ability to create new databases on the HFSQL server of the platform and to deploy one or more existing HFSQL (HyperFileSQL) databases on it.


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



Preparation


You must have:

- the identifier 

- and the password of the PCSCloud account.


The identifier and password have been supplied in the confirmation email when creating the PCSCloud account. 



Steps 


Connect yourself to the CLOUD dashboard, at the following address: https://pcscloud.net/.


Enable the remote HFSQL access, if not already done.

Then, click the "Management information" link.




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 the "Management of HFSQL server" section). 


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, NFDX and MMO files.


Still from the HFSQL Control Center, connect yourself 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.