Requirements

Sql Replication

Requirements

 

Synergy Development Environment

 

This example environment is currently developed using Synergy/DE V10.3.3 on a Windows system and should work on any higher version without modification. Our policy is to develop with and take advantage of the features of the latest and greatest development tools; there is no guarantee that the code will work with older development tools, however the bulk of the code should be fairly compatible with older versions.

 

If you wish to develop in Visual Studio then you must have Visual Studio 2015 or later, and have the latest version of Synergy DBL Integration for Visual Studio installed.

 

In addition to Windows, the software has also tested and implemented on Linux and OpenVMS systems.

 

Synergy License Requirements

 

All aspects of the SQL Replication environment are built using Synergy/DE, and therefor are subject to normal Synergy/DE licensing requirements. These requirements vary slightly depending on the platform that your Synergy application is hosted by.

 

License Requirements for a Windows Application Environment

 

In addition to your regular Windows Synergy/DE development licenses, you will also need:

 

One Windows Synergy runtime license (RUN10) to support the operation of the replicator process on your Linux server.

One Windows SQL Connection (SQL Server) license to allow connection to the SQL Server database.

One (ideally two) Windows Synergy Runtime licenses to support code generation and the bulk upload web service.

 

License Requirements for a Linux Application Environment

 

In addition to your regular Linux Synergy/DE development licenses, you will also need:

 

One Linux Synergy runtime license (RUN10) to support the operation of the replicator process on your Linux server.

One Windows SQL Connection (SQL Server) license to allow connection to the SQL Server database.

One (ideally two) Windows Synergy Runtime licenses to support code generation and the bulk upload web service.

 

License Requirements for an OpenVMS Application Environment

 

In addition to your regular OpenVMS Synergy/DE development licenses, you will also need:

 

One OpenVMS Synergy runtime license (AXP-RUN10 or I64-RUN10) to support the operation of the replicator process on your OpenVMS server.

One Windows SQL Connection for SQL Server license (SCSQ10) to allow connection to the SQL Server database.

One (ideally two) Windows Synergy Runtime licenses (RUN10) to support code generation and the bulk upload web service.

 

 

CodeGen Code Generator

 

The majority of the code the is included in this example, and indeed the majority of the code that would be needed to implement replication in your own environment, is produced by CodeGen.

 

If you wish to regenerate the included code, or use the supplied templates to generate code for your own environment then you must have CodeGen 5.2.6 or higher installed. You can always download the latest version of CodeGen can always be downloaded from https://github.com/Synergex/CodeGen/releases.

 

Synergy Repository Database

 

Because of the dependency on CodeGen, the record layouts for the files that you wish to replicate must be declared in a Synergy repository, as must the data files.

 

SQL Server Relational Database

 

This environment was originally created using Microsoft SQL Server 2012, and has been tested with SQL Server 2014, 2016 and 2017. The code should also work with later versions of SQL Server, and possibly some earlier versions.