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 |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2008-05-28 : 18:57:32
|
| Hi,We have an existing merged replication schema that works well. One of the tables is named audit. Currently this is a bidirectional transfer. However, we want a new audit table that will transfer data from the subscriber to the publisher and not the other way round. I have a script that was generated as a backup script when replication was first created. I have no idea which parameter to change in order to have the merge replication going from subscriber to publisher. Any advise is helpful. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-28 : 18:58:58
|
| Couldn't you just remove the object from merge replication and then use transactional replication for it?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2008-05-29 : 09:45:57
|
| Hi Tara,Thanks for your advise. We already have two other publications that are using merged replication and those are functioning extremely well. Now could I add this new audit table(with my requirement) as a transactional publication? That means both merged and transactional publication will work in unison? Please let me know. Thanks Regards. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-29 : 12:55:13
|
| I've never done it, but I don't see any reason why that wouldn't be possible. That's the whole point of transactional replication, to be able to do one-way replication from one database to another.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2008-05-29 : 15:21:41
|
| Thanks Tara for your help. I will try transactional on top of merge replication. Regards. |
|
|
|
|
|
|
Single direction transfer of data in merged public