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 |
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
 Posted - 2011-11-28 : 06:02:56
|
| Hi GuysI've a question around replication. I'm studying replication these days. Yesterday i configured transaction replication between two different instances of SQL Server 2008 R2. The replication is working fine but I'm confused that in real world we usually replicate production databases on to replicated databases , means we only replicate data between servers. We normally do not add any artefect into production database. Infact we make changes into replicated database and if everything is fine we publish changes to production database. Now my question is how can we send changes to publisher from subscriber (new tables with data). IS THERE ANY WAY ?Thanks in AdvanceSelect Knowledge from LearningProcess |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
Publis subscriber changes back to Publisher