Back

Topic

[KB359]HDS Replication and SCADA Basic

Tags: HDS, Scada Basic

Historical data
16 years ago
By RM
Options
Print
Applies to:

PcVue all versions.
Summary:

A SCADA Basic program to manage HDS replication.
Details:

To use it, unzip it and copy the .ini file in TP directory (the program can recreate it) and the .prg file in P directory.

  • It creates a cyclic action which execute several replication.
  • You need to create an ODBC link for each databass used in the replication.
  • For each replication, the program tests first both connections to databases (with ODBC links). If everything is OK, it inserts in a .bat file a command line which will execute replication since last one.
  • There is nothing to change in the program, just the .ini file to configure (OBDC links configuration and replications parameters).

Further information about replication and PcVue.

  • You can launch replication with the Maintenance Plan and Custom Tasks.
  • You just have to call 2 stored procedures:
    • EXEC sp__Launcher;
    • EXEC sp__Execution;
  • If you execute this task on DATABASE1, it will make a replication from DATABASE2 to DATABASE1. If you to do a bidirectional replication, just create 2 Custom Tasks with the previous lines on both databases.
  • Don’t forget to replace with the name of your replication.
  • Be careful, it will be executed with last parameters. If you’ve launched it with command line it will use the parameters passed not those from the XML file.

Download attachments: SCADA_replication.zip

Created on: 30 Dec 2010 Last update: 13 May 2024