February 27, 2014 at 7:59 am
Hi
We are using transactional replication. On the tables that are replicated, we filter on a CustomerID. We have added some new functionality to our app which requires me to add an additional value to the CustomerID. So for example when you look at the 'Publication Properties' , click 'Filter Rows' the n select one of the tables it will say in the 'Filter' box : WHERE [CustomerID] = 100
I need to change this to :WHERE [CustomerID] IN 100, 101
My question is will I need to generate a new snapshot after adding the new filter value to the required tables or does replication just start picking this up.
Also I have about 50 tables to work through so I can just click the edit button in the Publication Properties\Filter Rows dialogue box and manually add the value to the where statement. If I had say hundreds of tables that needed changing am i right in thinking I would just script the current publication and do a 'find and replace' for the current filter value/new values to be additionally added ?
February 27, 2014 at 8:31 am
Since you have many tables, I would recommend doing this via simple TSQL - the article below outlines the process quite well. If you have any further questions about it, feel free to let the community know 😛
http://technet.microsoft.com/en-us/library/ms146925(v=sql.100).aspx
http://technet.microsoft.com/en-us/library/ms151775(v=sql.100).aspx
I am pretty certain you will need to re-run the snapshots for these tables and re-initialize as well.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 9:37 am
ok thank you for your suggestions.
I had a feeling I'd have to re run the snapshot which isn't really a problem because it runs in a matter of minutes as opposed to hours for some larger db's !
🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply