Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ P&ID

TABLE OF CONTENTS

SQL Project Replication

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedMar 14, 2024
  • 2 minute read

The SQL replication concept is used to implement workshare for AVEVA P&ID projects using Microsoft SQL Server database technologies.

Prerequisites

  • The most recent version of the AVEVA P&ID application is installed on two server machines.

  • The SQL Server 2022 server /enterprise/ developer edition exe file is installed on two server machines.

  • SSMS 18.1 is installed on two server machines to connect two different SQL server authentications.

Sequence of Activities

  1. Install the same version of the SQL server edition on both machines.

  2. Define settings in the SQL Server Management Studio application on both machines.

  3. Connect both SQL authentication and windows authentication mode in SSMS.

  4. Open SQL Server Management Studio on one machine and connect the SQL server with windows authentication.

  5. Create a new SQL authentication user in AVEVA P&ID.

  6. Disconnect windows authentication and connect the SQL server with SQL authentication.

  7. Create two P&ID projects on both server machines.

  8. After Installing SQL Server Management Studio, create five transactional publications on one server, and five transactional subscriptions on the other server for the same projects.

  9. Verify bug validation from the publisher machine and make sure this is reflected on the subscriber machine.

Recommendations for Replication

If the user is setting configurations on both servers, one for publisher and another for client (subscriber) sites simultaneously, the user must reinitialize both publisher and subscriber sites after the configuration is created or updated from SQL Server Management Studio.

Select the Max Text Replication Size.

  • Use the Pull Subscription option for all merge replications to ensure the data from the subscriber to the publisher is synchronised properly.

  • For upgraded projects, if replication setup is already done, upgrade the project to the latest version of AVEVA P&ID.

  • For copied projects, the replication setup will not be copied. The user must create the publications and subscriptions manually to work with P&ID replication.

In This Topic
TitleResults for “How to create a CRG?”Also Available in