Exclude items in subscription articles in SSC

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Exclude items in subscription articles in SSC

Postby greg.strauss » Fri Dec 14, 2012 12:25 am

Is it possible to exclude/filter subscription articles from what is managed in SSC? I have a situation where the database I want to manage consists mostly of tables, views, and stored procedures that are replicated from another DB (which is also in SSC). I am also adding stored procedures etc. on the target side to suit reporting requirements (i.e. these stored procs would only be called in the replicated instance, not the original).

I suppose I could put stored procs in a separate schema and filter that way, but... what about objects like indexes? I have instances where I've added indexes to replicated tables on the subscriber side only that speed up reporting queries. I don't want these indexes on the publisher side (i.e. production DB) for performance reasons; they would never be used and would slow down insert/updates. Indexes can't be added into a separate schema since they are part of the table definition.


Posts: 4
Joined: Wed Oct 17, 2012 11:10 pm
Location: Victoria, BC

Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest