Building the Sample Environment on OpenVMS - Synergex/SqlReplication GitHub Wiki

IMPORTANT: To use this code on OpenVMS, you must be running Synergy 11.1.1 or later.

You must have an FTP server running on your OpenVMS system. If you do not, you must use some other mechanism to deploy the code to OpenVMS, following the general guidelines defined in SendToVMS.bat.

Refer to the various command procedure files in the VMS directory.

Basic steps to build on VMS:

• Determine an OpenVMS user account that you can use to deploy and build the code.

• In the VMS folder in the development environment, follow the instructions in the comments at the top of the SendToVMS.bat file to create a new file called SendToVMS.Settings.bat. In that file you will specify the ip address, ftp server port number, username and password that will be used to send the code to the VMS system.

• Execute the SendToVMS batch file to create the necessary folders and copy the code to the OpenVMS system. You should see output like this:

  Creating FTP script...
  Transferring files...
  Cleaning up...
  Done
  

• Use a terminal emulator to connect to and log in to the OpenVMS system.

• Move into the new [.REPLICATION] folder.

• Execute the BUILD.COM command procedure. You should see output like this:

  Setting up environment...
  Creating REPOSITORY...
  Loading repository schema...
  Prototyping library routines...
  Compiling library routines...
  Creating object library LIBRARY.OLB...
  Creating shared image LIBRARY.EXE...
  Linking shared image REPLICATOR_EXE:LIBRARY.EXE
  Compiling replicator and utilities...
  Cleaning up...
  

  If you do see these messages then the replication software has been successfully built and is ready for testing.

• Rename the file REPLICATOR_SETUP_EXAMPLE.COM to REPLICATOR_SETUP.COM and configure the various settings in the file based on your system and database environment. In particular you will need to configure REPLICATOR_DATABASE based on the SQL Server database you intend to use.

• Start replicator as a detached process by executing REPLICATOR_DETACH.COM

• Or start the replicator as an interactive process by executing REPLICATOR_RUN.COM

• Check the log file in the [.LOG] folder and ensure that replicator was able to connect to the database.

• Run REPLICATOR_EXE:EMPLOYEEMAINANCE.EXE and use it to add instructions to the replicator queue.

• Run REPLICATOR_EXE:REPLICATORMENU and test using the EMPLOYEE file.

• Use the S command in REPLICATORMENU or run REPLICATOR_EXE:REPLICATORSSTOP.EXE to stop the replicator process.