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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-25 : 08:05:12
|
| Chris writes "I posted this on my blog and was directed here.http://weblogs.asp.net/christoc/archive/2004/03/23/94571.aspxDoes 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!-Chris" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-25 : 13:00:55
|
| I would suggest going to:http://vyaskn.tripod.com/repl_ques.htmVyas has a lot of replication information on his web site. He is one of the MVPs here. He answers questions here occassionally, so hopefully he'll see this thread and give you some more help.I should mention that you can do what you have described using stored procedures with replication. If you use the stored procedure approach, you can modify them to what you need. These are named sp_MS<DMLType>_TableName in the user database if you selected to use them. Tara |
 |
|
|
|
|
|
I need help with a replication solution, not sure if SQL server will handle this?