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 |
|
CorpDirect
Yak Posting Veteran
92 Posts |
 Posted - 2006-01-06 : 17:48:46
|
| This should be in BOL but I just can't seem to find it. I know replication can be done between servers, and therefore between instances should work too -- but will (transactional) replication work between databases in one instance? ...and can a subset of objects (e.g. few tables) be selected for replication?If so, any pros and cons or gotchas for configuring either way?Thanks for the feedback!Daniel |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-06 : 18:23:03
|
| Yes to all I think.The benefit of using different servers is that if there is a problem with the destination server the transactions will accumulate on the distributor allowing the source server to clear the tr log and hence not crash when it runs out of space (until the distributor first gives up).Doing everything on a single server is useful for testing.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-06 : 18:26:23
|
| We replicate about 10% of our tables in one of our databases to another database on the same instance. This is done for reporting purposes.Tara Kizeraka tduggan |
|
|
|
CorpDirect
Yak Posting Veteran
92 Posts |
Posted - 2006-01-09 : 11:00:19
|
| Thanks for the responses! Much appreciated.Daniel |
|
|
|
|
|
|
Replication--between databases, or only instances?