PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Creating the replication
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
To implement an assisted replication, the first step consists in creating the replication with ReplicEdit.
The replication is created via a wizard.
The parameters defined in this wizard can be modified in the replication description.
Creating the replication
To create a replication:
  1. Start ReplicEdit from WINDEV, WEBDEV or WINDEV Mobile: on the "Tools" pane, in the "Database" group, expand "Replication" and select "ReplicEdit - Replication editor".
  2. If the startup wizard starts, select "Create a new replication".

    Replication wizard - Creating a replication

    Otherwise, select "File .. New". The replication creation wizard starts.
  3. In the replication creation wizard, specify the name and description of the replication. This name will be given to the replication file that will be created (.WER file).

    Replication wizard - Replication description

    Go to the next step.
  4. The description of the data files to synchronize must be loaded in ReplicEdit in order to create the replication.

    Replication wizard

    The wizard proposes 2 possibilities:
    • Use an analysis (WDD). To do so, select the path of the corresponding ".WDD" file and the associated password (if necessary).
      In this case, the analysis must contain an HFSQL Client/Server connection. This connection must be associated with the data files
      Indeed, ReplicEdit cannot be used to create a connection. You only have the ability to modify an existing connection.
    • Import from an HFSQL server. This option allows using the description of an HFSQL Client/Server database installed on a server (this method must be used if the application is deployed, for example). This solution is recommended if your files are described in HFSQL Client/Server in the analysis. ReplicEdit will automatically assign the connection used to the files to replicate.
      In this case, the wizard requests:
      • the connection parameters: address, port, user and password.
      • the database to replicate.
    In both cases, you must ensure the following:
    • the database on the HFSQL server contains only the data files described in your analysis. Otherwise, an error will occur at runtime.
    • The structures of these data files on the server must be strictly identical to their definitions in the analysis.
  5. The next step is used to choose the replication direction.


    The replication direction: The replication can be:
    • Bidirectional: data is synchronized on the master database and on the subscriber database.
    • Toward the subscriber only: data is synchronized from the master to the subscriber.
    • Toward the master only: data is synchronized from the master to the subscriber.
  6. The next step is used to choose the method for managing the modification conflicts.


    The management mode of conflicts is used to manage the case when the same records was modified both by the master and by the subscriber. Choose the rule to apply:
    • Most recent has priority: only the last modified record is taken into account.
    • Master always has priority: the record found in the master database is taken into account.
    • Subscriber always has priority: the record found in the subscriber database is taken into account.
      Caution: to avoid any problem, the server and the subscriber computers must use the same time.
  7. At the end of the wizard, you can add a file to the replication or go to the editor directly.
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment