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 |
|
khanewal
Starting Member
33 Posts |
 Posted - 2011-12-08 : 07:47:03
|
| HI Friends,Actually I'm trying to create a transactional replication on a SQL instance(2005) and I have four user databases, I've already created on one database and filter the articles, and working fine on other SQL instance (Subscirber 2008), now just wondering how I'll create Replication for other 3 user databases, Do I need to create 4 Publishers, 4 Subscribers ?or just 1 publisher and 1 subscriber for all 4 user databases.Thanks in Advance for your answers |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-12-08 : 08:15:37
|
| Publish once, subscribe 4 times.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
khanewal
Starting Member
33 Posts |
Posted - 2011-12-09 : 00:23:22
|
| Hi nigelrivett,can u please elaborate, how to achieve this. THanks |
|
|
|
|
|
|
Transactional Replication on Same instance