Step 3: Configure the push subscription

To initiate replication after publication creation, you will need to configure a push subscription to the destination PI AF database from the source SQL Server PI AF database. During replication, you can monitor data synchronization in SQL Server Management Studio.

1. Right-click the publication, then select New Subscription.

   The New Subscription Wizard opens.

2. Select the new publication that you created for your PI AF database, then select Next.

3. Select the option to run all agents at the distributor, then select Next.

4. To add the destination PI AF database, select Add SQL Server Subscriber from the Add Subscriber dropdown list.

5. Ensure the checkbox next to the destination PI AF database is selected, then select Next.

6. Select the accounts that will be used to connect to the distributor and subscriber (destination PI AF database), then select Finish.

   Important: To ensure that any created jobs support replication, use an account with appropriate permissions on the root snapshot folder.

7. After push subscription creation, start replication to begin pushing data to the destination PI AF database if it has not started automatically.

8. (Optional) Monitor the status of synchronization in SQL Server Management Studio.