SQL Agent Helper Classes

The SQL Agent requires custom plugin code to be generated for each structure/file/table to be replicated.

IMPORTANT: Deployments with SQL Server 2022

SQL Server 2022 did not correctly process time fields (HH:MM and HH:MM:SS) when processing data from parquet files, and we had to work around the problem in the code generated SQL Helper classes. Microsoft corrected the issue in SQL Server 2025, but this was a breaking change that we once again had to code our way around. By default the code in the generated SQL helper classes assumes that SQL Server 2025 (or later) is being used, but if SQL Server 2022 is being used, and the application data files include time fields in replicated tables, it is important to set the Sql2022TimeProcessing property in the Database section of MasterConfig.json to true in order to have SQL Server process the time fields correctly.

Also, if an environment is subsequently upgraded from SQL Server 2022 to a later version, it is important to set the property to false, or remove it from the configuration file, as part of the upgrade.

Repository Setup

Coming soon.

Code Generation

Coming soon.

Building and Distributing the Code

Coming soon.