Create Transactional Subscription for Project ADMIN Database

This procedure is used to create a transactional subscription for the Project ADMIN database.

1. Launch the SQL Server Management Studio application and connect to the SQL Server where the transactional subscription is to be created.

2. Expand the Replication node and select the Local Subscriptions node.

3. Right-click and select New Subscriptions from the menu.

   

4. The New Subscription Wizard dialog is then displayed, click the Next button.

   

5. Select Find SQL Server Provider from the menu.

   

6. The Connect to Server dialog is then displayed. Specify the SQL credentials of the publisher machine.

   

7. Click Connect to close the Connect to Server dialog and return to the New Subscription Wizard dialog.

8. Select the required publication and click the Next button.

   

9. Select the required distribution agent option and click the Next button.

   

10. Select the required subscribers and click the Next button.

    

11. Click the Browse button.

    

12. The Distribution Agent Security dialog is then displayed. Specify the SQL credentials, username and password of the publisher machine.

    

13. Click OK to close the Distribution Agent Security dialog and return to the New Subscription Wizard dialog.

14. Click the Next button.

    

15. Select Run continuously from the Agent Schedule menu and click the Next button.

    

16. Select Immediately from the Initialize When menu and click the Next button.

    

17. Select the Create the subscription(s) option and click the Next button.

    

18. Click the Finish button.

    

19. When the subscription is successfully created, click Close to close the New Subscription Wizard dialog.

    

Repeat the process to:

• Create a merge publication for the PROJECT database.

• Create a merge subscription for the PROJECT database.

• Create a transactional subscription for the PROJECT database.

• Create a merge publication for the REPORT database.

• Create a merge subscription for the REPORT database.

• Create a transactional subscription for the REPORT database.

The example indicates a complete set of publications and subscriptions created on the SQL servers.