1 Reply Latest reply on Oct 4, 2019 2:06 AM by Carl Wilson

    Smart Reporting - SQL Database Transactional Replication?

    Jeff Brock
      Share This:

      Environment:

      BMC Remedy 9.1.03

      SQL Server 2016 Standard

       

      We are configuring a standalone AR server with Smart Reporting using a read-only database. We are to be able to produce real-time dashboards, so we are looking at transactional replication. Our DBA team is telling us that SQL Server Transactional Replication requires that all replicated objects have Primary Keys defined.  They are reporting that 141 of the 8,492 tables in ARSystem don’t have primary keys defined.

       

      Is anyone using transactional replication with SQL? If so, how did you resolve the Primary Key issue?