AVEVA™ P&ID

Create Transactional Publication for Project ADMIN Database

Save PDF

TABLE OF CONTENTS

Create Transactional Publication for Project ADMIN Database

Save PDF

Last UpdatedMar 14, 2024
3 minute read

Engineering

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

Launch the SQL Server Management Studio application and connect to the SQL Server where the transactional publication is to be created.
Expand the Replication node and select the Local Publications node.
Right-click and select New Publication from the menu.
The New Publication Wizard dialog is then displayed, click the Next button.

Note: Steps 5,6 and 7 are only displayed when a transactional publication is first created. When subsequent transactional publications are created, the steps are omitted and Step 8 is displayed.
Select the required server distributor option and click the Next button.
Select the required SQL server agent start option and click the Next button.
The default snapshot folder path is then displayed.

Specify the location for the snapshot folder and click the Next button.

Note: The snapshot folder must be a shared folder.
Select the required project for replication and click the Next button.
Select the Transactional publication option and click the Next button.
Select the required Admin tables which are supported for replication and click the Next button.
Specify the filter table rows options and click the Next button.
Specify the snapshot agent run options and click the Next button.
Click the Security Settings button.
The Snapshot Agent Security dialog is then displayed. Specify the SQL credentials of the publisher machine.
Click OK to close the Snapshot Agent Security dialog and return to the New Publication Wizard dialog.
Click the Next button.
Select the Create the publication option and click the Next button.
Specify the Publication name and click the Finish button.
When the publication is successfully created, click Close to close the New Publication Wizard dialog.