Help / WLanguage / Managing databases / HFSQL / Managing replications / Universal replication
  • Overview
  • Principle of the assisted universal replication
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
To easily establish the universal replication between the data of a remote application and a central database, WINDEV and WEBDEV allow you to:
  • create a replication via a replication editor (ReplicEdit). This editor is used to define the characteristics of a replication.
  • implement an automatic replication on the data of an application. The replication is directly performed by the end users via two tools:
  • implement a programmed replication included in an application via WLanguage functions. These functions are used to handle a replication and to perform the synchronization.
    For more details, see Implementing a programmed assisted universal replication.
Principle of the assisted universal replication
The purpose of the assisted universal replication is to propose a quick replication for any type of application.
The assisted universal replication proposes the following modes of replication:
  • direct replication: The replication is directly performed between the local database and the master database. This replication mode is recommended when a computer must connect to the local network for example. This replication mode requires no specific configuration.
  • replication by server: the replication is performed via a replication server. The transfer of replicas is automatically managed.
The replication via server can be performed with immediate replica: in this case, the data is immediately synchronized. The subscriber database sends the data to replicate, the replication is performed and the subscriber database retrieves the data to update. This operation can take quite a long time. This replication mode is recommended for a daily synchronization for example (a salesperson synchronizes every evening with the office).
The replication by server can be performed with delayed replica: in this case, the data is synchronized when the exchanges are performed with the server. When the server receives the data to replicate, it automatically prepares the data to return. This data will be returned during the next synchronization. This replication mode is recommended for a periodic synchronization (whenever an order is placed for example).
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 version required
  • Version 12
This page is also available for…
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help