I’m trying to setup BigFix Insight in our dev environment. Requirement is that BigFix insights will only work with SQL Server 2017 or higher and it’s recommended to use SQL Replica vs. reporting directly against BFEnterprise.
I’ve upgrade SQL Server 2019, and did initial setup of DB Replica. The replica is working as expected but I noticed that WebUI does not want to start anymore, I see following error message in datasync.log
'Cannot drop the table \'webui.custom_computed_fixlet_counts\' because it is being used for replication.',
The SQL Replica I created was “Transactional Publication”, for reading SQL documentation this would ensure any changes performed on BFEnterprise would automatically sync’ed with Replica DB.
- does anybody know what’s best SQL replica solution to use?
- in my setup I just replicated full BFEnterprise database (DEV Environment) is this required? Documentation does not really talk about tables that are needed for BigFix Insights
Thx for any help.