DotNetNuke Developer Chris Hammond

DotNetNuke Core Team Member

News

Thanks for visiting my blog, you can find more about me at ChrisHammond.com or on my company's website at Engage Software.

Cool Sites

My domains

Projects

Where to go for SQL replication advice?

Does anyone have any suggestions on where to go for SQL replication questions/consulting?

Here at work we've setup a replicating system, but it doesn't work well, so we are hoping to find a better out of the box solution.

We have one master database that holds all of the information for all our properties. There are 5-6 tables in that database that have a property code field that is property specific. We need to replicate this whole database out to 150+ properties. The catch is that in the 5 or 6 tables that have a property code column, we only want to send the data for that particular property to each property, we don't want to send all the information, for all properties, to every property. The rest of the tables should all replicate as normal. We also want to get property specific data and pull it back into the master tables.

Anyone have any experience with anything like this? Any place to begin looking?

Thanks for your help!

Posted: Mar 23 2004, 10:37 AM by Chris Hammond | with 5 comment(s)
Filed under: ,

Comments

Justin said:

There are quite a few SQL Server MVPs (and alot of other smart people too) that could probably help you out.
# March 23, 2004 1:39 PM

Justin said:

I suppose I should remember to mention where :) ... http://www.sqlteam.com
# March 23, 2004 1:40 PM

Jeff said:

At my last gig, we brought in a guy from a local shop. It really made all the difference. It seems like an expense, but while you and your peeps try to figure stuff out, a good consultant shows up and says, "So if you need this, you do this, let me show you." Bam! It's done. Worth every penny.
# March 23, 2004 2:34 PM

Christoc said:

We aren't opposed to paying someone to do it, we just need to find the right person for the job, and so far our local shops can't do what we need/want on a consistant basis.
# March 23, 2004 2:40 PM

Christoc said:

Thanks again to Hilary! He told me what I needed to know!
# March 25, 2004 12:34 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)