Set up one-way subscriptions for SQL Server - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13

You use the Microsoft SQL Server Management Studio to setup one-way subscriptions for the Catalog, Catalog schema, Site, and Site schema. See your SQL Server documentation for information on the Microsoft SQL Server Management Studio.

Each user you specify in the wizards referenced in this procedure must have administrator privileges to connect to each server.

  1. From Microsoft SQL Server Management Studio, connect to the Host machine.

  2. In the Object Explorer, right-click the publication created on the Host machine for the appropriate database.

  3. Expand Replication > Local Publications.

  4. Right-click the Site, and select New Subscriptions to open the New Subscription Wizard.

  5. Click Next to go to the Publication page of the wizard. Select the publication to which to add a new subscriber, and click Next.

  6. On the Distribution Agent Location page of the wizard, select Run all agents at the distributor, and then click Next.

  7. On the Subscribers page, select the remote server name. Do not check Subscriber for the Host machine. If you have more than one Satellite, select Add Subscriber and add all of the Satellite locations (one at a time) before continuing.

  8. When you are finished adding Subscribers, click Next to continue.

  9. On the Distribution Agent Security page, specify the security information for each subscription. Click the ellipsis button to display the Distribution Agent Security dialog.

    Specify only users that can connect to the distributor. For Connect to the Subscriber, make sure you specify a user with enough access on the remote server. If you have more than one subscriber (Satellite), do this for each subscriber. Click OK to accept your security settings, and then click Next to continue through the New Subscription Wizard.

    The distribution and log reader agent security details can be configured to run under the SQL Server Agent service account provided all necessary database privileges are met for the actions that the agents will perform.

  10. The next page of the wizard is the Synchronization Schedule page. The most common selection is Run continuously, but you should set it as needed for your database setup. Click Next.

  11. On the Initialize Subscriptions page, if you are sure the databases have not been modified since the backup, clear the Initialize check box for the Catalog, Catalog schema, and Site schema, and click Next.

    Clearing the Initialize check box allows the subscription to start faster as no data needs to be sent to the server. However, if the data has changed since your backup, the remote server will not receive the changes. We strongly recommend avoiding modification of the databases and using the "quick start without initialization" option, especially in the case of larger databases, such as the Catalog database.

  12. Click Next to Create the subscriptions, and then Finish on the final wizard page. The final wizard page should display a Success status when the subscription is created.

  13. Run the New Subscription Wizard again for the Site schema, Catalog, and Catalog schema. Do not create a subscription for the Model database.