Set up Global Workshare with SQL Server databases - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
12.1 (2019)

GWC_SQL

After you create the SQL Server Distributor Agent, you can set up the Global Workshare configuration (GWC) for the SQL Server databases. The steps discussed in this section assume some familiarity with the Project Management environment for Global Workshare and are targeted to specific SQL Server settings.

Before starting your configuration for Global Workshare with SQL Server, you need to decide how the data is managed or controlled.

For the catalog, catalog schema, site, and site schema, the Host should control the data. The other machines are Satellites of the Host. The Host is a Publisher of site, site schema, catalog, catalog schema, and model data to the Satellites and a Subscriber of model data from the Satellites. The Satellites are Subscribers to the Host for site, site schema, catalog, catalog schema, and model data. They are Publishers of model data to the Host. In small and midsize configurations, the database server is usually its own distributor. However, in the case of large configurations or multiple smaller configurations, it is possible to use a dedicated distributor server. You can specify whether you want to use a dedicated distributor server when you configure the SQL Server Distributor Agent.

One-Way Transactional Replication

Using One-Way Transactional Replication, you have a Host machine for your catalog, catalog schema, site, and site schema. This means that the Host machine communicates information to your Satellite machines, but the Satellites do not communicate information back to the Host. The Host machine is the Publisher, and the Satellites are Subscribers. The communication is all one-way from the Host to the Satellites.

Two-Way (Peer-to-Peer) Replication

For the model database, you set up Two-Way (Peer-to-Peer) Replication. The Host machine operates as both a Publisher and a Subscriber, pushing information to the Satellites and receiving changes from them. Likewise, your Satellite machines are Publishers and Subscribers so they can communicate changes to the Host and receive information from the Host. The communication is two-way.

What do you want to do?