Overview

When a SQL Server Publication is created the Cardholders table is configured to replicate all of the stock columns. When adding additional fields, steps must be taken to ensure they are properly replicated to all subscribers.

Publisher

Enable Replicate Schema Changes

1. Using SQL Server Management Studio, connect to the SQL Publisher
2. Expand the Replication Folder
3. Expand Local Publications
4. Right click on the AIUniversal publication and select properties
5. Select Subscription Options
6. Set Replicate schema changes to True

   More on this option can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/replicate-schema-changes?view=sql-server-ver15

7. Click OK

Create Additional Fields

With Schema changes replicating, additional fields can be created as outlined in the KB: Adding In Custom Defined User Fields In Access It! Universal.NET.

Disable Replicate Schema Changes
If preferred, the replicate schema change can be disabled after all newly created fields are replicated to subscribers.

1. Using SQL Server Management Studio, connect to the SQL Publisher
2. Expand the Replication Folder
3. Expand Local Publications
4. Right click on the AIUniversal publication and select properties
5. Select Subscription Options
6. Set Replicate schema changes to False
7. Click OK

Subscriber
The following must be performed for each subscriber

Database Utility

1. Run the Database Configuration Utility
2. Connect to the Subscriber instance
3. Select Cardholder Fields
4. Click Save
5. Close the Database Configuration Utility
6. Restart the Access It! Universal.NET service