Publish and ignore system/replication tables

adam 1 Reputation point
2020-11-25T23:08:52.663+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,949 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.