Knowledge Base

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