PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Functions for managing the assisted replication
  • Functions for managing the universal replication
  • Functions for managing the logged replication
  • Functions used to handle the replication of HFSQL servers
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
Different types of replication are proposed:
  • the assisted replication. This replication mode is used to easily define the records to replicate via ReplicEdit. Then, the records are replicated by ReplicSynchro. This replication mode is using the universal replication. Specific WLanguage functions are used to handle the replications.
    Versions 19 and later
    The assisted universal replication is available for the iOS and Android applications. See Replication of mobile data (Android or iOS) for more details.
    New in version 19
    The assisted universal replication is available for the iOS and Android applications. See Replication of mobile data (Android or iOS) for more details.
    The assisted universal replication is available for the iOS and Android applications. See Replication of mobile data (Android or iOS) for more details.
  • the universal replication. The purpose of universal replication is to keep several databases synchronized. These databases can have different types (HFSQL, Oracle, ...). The universal replication is using a centralized model: all the databases are synchronized with a master database. Then, the master database applies the modifications to the other databases. Several WLanguage functions are used to implement the universal replication.
  • the logged replication. The logged replication is using the log process to keep the remote HFSQL databases updated. Several WLanguage functions are used to implement the logged replication. You also have the ability to use WDReplic.
  • Versions 18 and later
    the replication between HFSQL servers. This replication mode is used to update the data found on HFSQL servers linked 2 by 2.
    New in version 18
    the replication between HFSQL servers. This replication mode is used to update the data found on HFSQL servers linked 2 by 2.
    the replication between HFSQL servers. This replication mode is used to update the data found on HFSQL servers linked 2 by 2.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Functions for managing the assisted replication
The following functions are used to implement the assisted universal replication (replication created from ReplicEdit):
Versions 22 and later
ReplicDeleteSubscription
New in version 22
ReplicDeleteSubscription
ReplicDeleteSubscription
Deletes the subscription of a replication on the replication server.
Versions 12 and later
ReplicInfo
New in version 12
ReplicInfo
ReplicInfo
Returns information about a replication.
Versions 12 and later
ReplicInitialize
New in version 12
ReplicInitialize
ReplicInitialize
Initializes or reinitializes a replication defined by the replication editor (ReplicEdit).
Versions 12 and later
ReplicOpen
New in version 12
ReplicOpen
ReplicOpen
Opens a replication in direct mode or with a replication server.
Versions 12 and later
ReplicSynchronize
New in version 12
ReplicSynchronize
ReplicSynchronize
Synchronizes the data corresponding to a replication.
Functions for managing the universal replication
The following functions are used to implement a universal replication. See Implementing the universal replication for more details.
Versions 09 and later
HCreateMasterReplica
New in version 09
HCreateMasterReplica
HCreateMasterReplica
Creates the description file of a Master Replica (logged replication or universal replication).
Versions 09 and later
HCreateMoveableReplica
New in version 09
HCreateMoveableReplica
HCreateMoveableReplica
Creates a movable replication.
Versions 09 and later
HCreateSubscriberReplica
New in version 09
HCreateSubscriberReplica
HCreateSubscriberReplica
Creates the description file of a subscriber replica.
Versions 10 and later
HRecreateSubscriberReplica
HRecreateSubscriberReplica
Re-creates the description file of a subscriber replica (universal replication only) according to the information of the master replica (.RPM and.SYN files).
Versions 09 and later
HRplDeclareLink
New in version 09
HRplDeclareLink
HRplDeclareLink
Declares a (1, 1) (0, n) link between two tables.
Versions 09 and later
HRplFilterProcedure
New in version 09
HRplFilterProcedure
HRplFilterProcedure
Defines the WLanguage procedure that will be called whenever a replication operation is performed on a specific file.
Versions 12 and later
HRplManageFile
New in version 12
HRplManageFile
HRplManageFile
Defines the options used for the universal replication of a file:
  • the replication direction.
  • the management mode of conflicts.
Versions 12 and later
HRplManageItem
New in version 12
HRplManageItem
HRplManageItem
Specifies the replication options for an item: the item can be replicated or not.
Versions 10 and later
HRplPass
New in version 10
HRplPass
HRplPass
Defines the passwords used to protect the movable replicas for the universal replication.
Versions 09 and later
HSetReplication
New in version 09
HSetReplication
HSetReplication
Temporarily disables (or re-enables) the replication.
Versions 09 and later
HSynchronizeReplica
New in version 09
HSynchronizeReplica
HSynchronizeReplica
Synchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica.
Functions for managing the logged replication
The following functions are used to implement a logged replication. See Programming a logged replication for more details.
Versions 09 and later
HChangeRplDir
New in version 09
HChangeRplDir
HChangeRplDir
Modifies the location for the description of subscriber replica (RPL file).
Versions 09 and later
HCreateMasterReplica
New in version 09
HCreateMasterReplica
HCreateMasterReplica
Creates the description file of a Master Replica (logged replication or universal replication).
Versions 09 and later
HCreateMoveableReplica
New in version 09
HCreateMoveableReplica
HCreateMoveableReplica
Creates a movable replication.
Versions 09 and later
HCreateSubscriberReplica
New in version 09
HCreateSubscriberReplica
HCreateSubscriberReplica
Creates the description file of a subscriber replica.
Versions 09 and later
HInfoReplica
New in version 09
HInfoReplica
HInfoReplica
Returns information about the specified replica.
Versions 09 and later
HInitSubscriber
New in version 09
HInitSubscriber
HInitSubscriber
Initializes the range of automatic identifiers for the description file of subscriber replica (".RPL" extension).
Versions 09 and later
HSetReplication
New in version 09
HSetReplication
HSetReplication
Temporarily disables (or re-enables) the replication.
Versions 09 and later
HSynchronizeReplica
New in version 09
HSynchronizeReplica
HSynchronizeReplica
Synchronizes the master replica and the subscriber replica: the operations performed on one of the replicas are transferred into the other replica.
Functions used to handle the replication of HFSQL servers
Versions 18 and later
The functions below are used to implement a replication between 2 HFSQL servers. See Programming a replication of HFSQL servers for more details.
Versions 18 and later
HRSAddConfig
New in version 18
HRSAddConfig
HRSAddConfig
Adds a replication between two HFSQL server onto the master server.
Versions 18 and later
HRSDeleteConfig
New in version 18
HRSDeleteConfig
HRSDeleteConfig
Deletes a replication between two HFSQL servers.
Versions 18 and later
HRSExecute
New in version 18
HRSExecute
HRSExecute
Immediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling.
Versions 18 and later
HRSInfo
New in version 18
HRSInfo
HRSInfo
Allows you to read the configuration of the replication for a HFSQL server taking part in one or more replications.
Versions 18 and later
HRSInit
New in version 18
HRSInit
HRSInit
Configures a HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
Versions 18 and later
HRSListConfig
New in version 18
HRSListConfig
HRSListConfig
Lists the replications available on a master HFSQL server.
Versions 18 and later
HRSModifyConfig
New in version 18
HRSModifyConfig
HRSModifyConfig
Modifies some parameters of an existing replication between two HFSQL servers.
Versions 23 and later
HRSWaitForDataProcess
New in version 23
HRSWaitForDataProcess
HRSWaitForDataProcess
Used to wait for:
  • the data to replicate on the master server to be sent to the subscriber server.
  • the data to replicate received on the subscriber server to be entirely applied.
The replication between HFSQL servers is also using the following type of data:
hRSConfigThe hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL servers.
New in version 18
The functions below are used to implement a replication between 2 HFSQL servers. See Programming a replication of HFSQL servers for more details.
Versions 18 and later
HRSAddConfig
New in version 18
HRSAddConfig
HRSAddConfig
Adds a replication between two HFSQL server onto the master server.
Versions 18 and later
HRSDeleteConfig
New in version 18
HRSDeleteConfig
HRSDeleteConfig
Deletes a replication between two HFSQL servers.
Versions 18 and later
HRSExecute
New in version 18
HRSExecute
HRSExecute
Immediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling.
Versions 18 and later
HRSInfo
New in version 18
HRSInfo
HRSInfo
Allows you to read the configuration of the replication for a HFSQL server taking part in one or more replications.
Versions 18 and later
HRSInit
New in version 18
HRSInit
HRSInit
Configures a HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
Versions 18 and later
HRSListConfig
New in version 18
HRSListConfig
HRSListConfig
Lists the replications available on a master HFSQL server.
Versions 18 and later
HRSModifyConfig
New in version 18
HRSModifyConfig
HRSModifyConfig
Modifies some parameters of an existing replication between two HFSQL servers.
Versions 23 and later
HRSWaitForDataProcess
New in version 23
HRSWaitForDataProcess
HRSWaitForDataProcess
Used to wait for:
  • the data to replicate on the master server to be sent to the subscriber server.
  • the data to replicate received on the subscriber server to be entirely applied.
The replication between HFSQL servers is also using the following type of data:
hRSConfigThe hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL servers.
The functions below are used to implement a replication between 2 HFSQL servers. See Programming a replication of HFSQL servers for more details.
Versions 18 and later
HRSAddConfig
New in version 18
HRSAddConfig
HRSAddConfig
Adds a replication between two HFSQL server onto the master server.
Versions 18 and later
HRSDeleteConfig
New in version 18
HRSDeleteConfig
HRSDeleteConfig
Deletes a replication between two HFSQL servers.
Versions 18 and later
HRSExecute
New in version 18
HRSExecute
HRSExecute
Immediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling.
Versions 18 and later
HRSInfo
New in version 18
HRSInfo
HRSInfo
Allows you to read the configuration of the replication for a HFSQL server taking part in one or more replications.
Versions 18 and later
HRSInit
New in version 18
HRSInit
HRSInit
Configures a HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
Versions 18 and later
HRSListConfig
New in version 18
HRSListConfig
HRSListConfig
Lists the replications available on a master HFSQL server.
Versions 18 and later
HRSModifyConfig
New in version 18
HRSModifyConfig
HRSModifyConfig
Modifies some parameters of an existing replication between two HFSQL servers.
Versions 23 and later
HRSWaitForDataProcess
New in version 23
HRSWaitForDataProcess
HRSWaitForDataProcess
Used to wait for:
  • the data to replicate on the master server to be sent to the subscriber server.
  • the data to replicate received on the subscriber server to be entirely applied.
The replication between HFSQL servers is also using the following type of data:
hRSConfigThe hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL servers.
Related Examples:
WD Universal Replication Training (WINDEV): WD Universal Replication
[ + ] This examples explains how to use the universal replication to synchronize data of different sites.
The universal replication is used to synchronize the data of a site (master site) with the same data of one or more replicated sites (subscriber sites). The data structures are identical on each site but they can be exploited via different data managers. HFSQL Classic and Access will be used in this example.
The example presents the processes that must be included in your applications to allow the user, via a simple action (menu, button, ...), to:
- create a master replica,
- create one or more subscriber replicas,
- see and modify the data of these replicas,
- export the created or modified data to a site (portable replica),
- import the created or modified data into another site...
Minimum required version
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment