Functions for managing the replication

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Overview
Functions for managing the assisted replication
Functions for managing the universal replication
Functions for managing log-based replication
Functions used to handle the replication of HFSQL servers
Replication functions (for function book)

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Functions for managing the replication

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, ...). Universal replication uses a centralized model: all 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.
log-based replication. Log-based replication uses logs to keep the remote HFSQL databases up to date. Several WLanguage functions are used to implement log-based replication. It is also possible to use the WDReplic tool.
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.

Remark: 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 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 New in version 10 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	Sets the passwords used to protect the universal replication files.
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 log-based replication

The following functions are used to implement log-based replication. See Program a log-based 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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.

The replication between HFSQL servers is also using the following type of data:


hRSConfig	The 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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.

The replication between HFSQL servers is also using the following type of data:


hRSConfig	The 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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.

The replication between HFSQL servers is also using the following type of data:


hRSConfig	The hRSConfig type is used to define the advanced characteristics of a replication between 2 HFSQL servers.

Replication functions (for function book)

Versions 18 and later
The functions for managing the different types of replication are as follows:


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 10 and later HRecreateSubscriberReplica New in version 10 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	Sets the passwords used to protect the universal replication files.
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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.
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.
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 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.

New in version 18
The functions for managing the different types of replication are as follows:


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 10 and later HRecreateSubscriberReplica New in version 10 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	Sets the passwords used to protect the universal replication files.
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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.
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.
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 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.

The functions for managing the different types of replication are as follows:


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 10 and later HRecreateSubscriberReplica New in version 10 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	Sets the passwords used to protect the universal replication files.
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	Reads the replication configuration for an HFSQL server that takes 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 replication data on the master server to be sent to the subscriber server. the replication data received on the subscriber server to be entirely applied.
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.
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 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.

Related Examples:

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...