Publish and ignore system/replication tables
I'm wondering if there is a way to publish and ignore system tables.
When publishing our replication database - we have 'Drop objects in target but not in source" checked on so the replication objects (system tables) are not deleted, when we publish after recreating replication.
The issue then is over time, objects like SQL views we've deleted from the project are not deleted when publishing and we have to remember to manually delete them with a script.
Has anyone determined the best way to publish to a replication database and include drops on all objects except the replication (system table) ones?
Thanks