|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49,
Visits: 154
|
|
Hi,
We have 5 databases in two different servers and its already configured in log shipping and its running successfully also. But now i want configure merge replication from those 5 existing databases. Is it possible to achieve?
Kindly advice me on this...
Pradeep.
        
Pradeep
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:05 PM
Points: 99,
Visits: 98
|
|
| Yes it is possible but why you want to do that when the logshipping already been configured on the same databases?
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49,
Visits: 154
|
|
Its for business requirements...
Eg:
1) Source database 'A' already configured log shipping to Destination database 'B' (Its working fine)
2) Same Source database 'A' need to be configure merge replication to other Destination database 'X' (This is requirement)
Source databases is same for both log shipping and merge replication.
Is it achievable?
Thanks...
Pradeep.
        
Pradeep
|
|
|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
|
|
Sure it's possible. It's just going to be a normal merge replication setup.
Gail Shaw Microsoft Certified Master: SQL Server 2008, MVP SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49,
Visits: 154
|
|
many thanks...
Pradeep.
        
Pradeep
|
|
|
|