Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
GustiX
Starting Member
28 Posts |
Posted - 2011-11-17 : 06:55:04
|
I am creating a customized replication setup program.Some of the tables we are replicating (transactional)have filters. I am looking through the distributiondatabase and I have found most of what I am lookingfor but I can't find a reference anywhere to thearticle filter (or the syncobj_ view)I would expect it to be in the MSarticles system table...Help! |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-17 : 11:03:41
|
Vertical (column) filters are in sysarticlecolumns in the publisher db.Horizontal (static row) filters are stored in the sys.sysarticles system view in the distribution db. |
|
|
GustiX
Starting Member
28 Posts |
Posted - 2011-11-17 : 14:24:40
|
exactly what I was looking for, thanks! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-17 : 15:08:36
|
You're welcome |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-17 : 22:55:08
|
By the way, if you're creating a custom installation program, may want to have a look at RMO.Or, in most cases, the script you generated the original setup with can be deployed (with minor modification, or none at all) anywhere. I imagine if you're deploying in many environments that there are environment specific differences you need to query out (server names for example).In any event, I'd love to see some of what you come up with.Replication, especially transactional and peer to peer, is one of my favorite features of SQL Server -- something I truly enjoy, a little hobby of mine I've setup replication on a good number of systems, some local, some geographically dispersed; and have presented on the topic. But always looking to learn something new. Would love to hear more about your project. |
|
|
victy23
Starting Member
3 Posts |
Posted - 2011-12-06 : 04:32:36
|
I'm new to here.Just to say hello to you.Love smile,love life. |
|
|
|
|
|
|
|