Are you trying to selectively replicate only certain tables or do you want a full replica of your Maximo database? If you're looking for a full replica, I'd look to utilize SQL Availability Groups instead. To have a read-only copy you need Enterprise which isn't cheap but it might be a better option for you.
Otherwise I believe Merge is your only option. My concern in general with replication was what would happen during a patch/upgrade/db config when Maximo drops and recreates tables? Since replication is at that table level, I'm not sure how well that would work.
------------------------------
Steven Shull
IBM
------------------------------
Original Message:
Sent: 07-30-2021 13:43
From: Atish Jadhav
Subject: Replication of SQL Server for Maximo
We are trying to set up a Replication of SQL Server for Maximo.
As per the IBM Maximo 7.6.x performance and tuning guide, this is supported, however when we set up the 2nd SQL Server instance and Database, we are not able to set up Peer to Peer because Maximo Tables are missing an SQL Primary Key. If we added this to each table is this supported, and does IBM have support documentation on how to?
Currently found we can set up Replication with Merge Replication.
The purpose of this is to offset the impacts of SQL Store Procedures, Crontasks and Reports to be executed on the Maximo replicated Database.
#technicalexperts #database #MSSQLserver #databasereplication.
thanks in advance.
#Administration
------------------------------
AJ
ESOL
------------------------------