Replication:rowguid column value
-
Friday, November 16, 2012 7:34 AM
I have a scenario like this.i have two replication setup in my sql server.let us consider database name are A, A1, B, B1
database A is publisher and A1 is subscriber of a replication.i have another replication where B is publisher and B1 is subscriber.both replications are merge replication scheduled to run once in a day.
During day 1 of replication some rows will be replicated from database A to A1 by replication and also from B to B1 .Now during day 2 i shift some rows from database A to B along with rowguid column manually .So in day 2 does it cause any problem for replication between B and B1? Because i have manually transfered rows from A to B along with row guid column value. Does replication work between B and B1 properly as it's rowguid column value has already involved in replication in database A in day 1.Also will it cause any problem for replication between A and A1
i think you have understood my question.thank u.
All Replies
-
Friday, November 16, 2012 1:09 PMModerator This will work fine.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Sunday, November 18, 2012 12:09 AM
-
Saturday, November 17, 2012 11:24 PM
hi navneeth,
The only requirement to set up the replication is all participating tables should have a primary key.
Coping data form A to B doesn't cause any issue with replication. rowguid data will be treated as a unique identifier and cause no issues like an identity column. Every time you insert a row will generate a new GUID from a range of values. So you can confidently implement this scenario.
Thanks
kumar
-
Monday, November 19, 2012 12:05 PM
thank u for your replies..
i am adding rowguid values manually because i will be shifting rows from a table to another table manually.So rowguid will be copied from another table.
-
Monday, November 19, 2012 4:05 PMModerator If you are taking rows from one merge replicated table and putting it into another merge replicated table - this will not work. The same is true of tables published in updateble subscriptions.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Proposed As Answer by Shulei ChenModerator Monday, November 26, 2012 7:53 AM
-
Tuesday, November 20, 2012 4:56 AM
hi hilary..
If i am copying rows from one table of database to another table in another database then merge replication won't work?What is the reason?
.png)
