/
ACM SQL Updates and Replication

ACM SQL Updates and Replication

Owned by Dennis Waehner
Mar 31, 2023

Troubleshooting ACM SQL Updates when using Replication

  • If you are using SQL redundancy and you are replicating all objects, you only need to update the primary database and SQL replication will take care of updating all redundant servers.
  • If you are only replicating a few objects you will need to disable replication, update the primary database and then re-do Step 6 for each subscriber database. After all databases have been updated, then you may reenable replication.
  • If you are only replicating a few objects and one of those objects will be updated by the ACM SQL Scripts, you will need to remove it as an article of replication, perform the update and then add it back.  


Related Microsoft Documentation:

Related content

SQL Merge Replication for ACM (SQL Server 2012 +)
SQL Merge Replication for ACM (SQL Server 2012 +)
ACM User Guide
More like this
ACM and Windows DCOM Hardening
ACM and Windows DCOM Hardening
ACM User Guide
Read with this
Remove and Add a Table as an Article of Replication
Remove and Add a Table as an Article of Replication
ACM User Guide
More like this
Installation
Installation
ACM User Guide
Read with this
Upgrade an Existing ACM
Upgrade an Existing ACM
ACM User Guide
More like this
Out of Maintenance Software Release Contents
Out of Maintenance Software Release Contents
ACM User Guide
Read with this

For assistance, please submit a ticket via our Support Portal, email autosol.support@autosoln.com or call 281.286.6017 to speak to a support team member.