SQLTeam.com | Weblogs | Forums

SQL server replication


#1

Hi, Can anyone guide me on peer-to-peer replcation alternative as it required enterprise edition of sql server.


#2

Which version of SQL SErver are you using? This link shows the features per Edition and Standard Edition shows support for replication: https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx#Replication


#3

Thanks for your reply.I am using 2012 std version, we want to have the data from some tables to be replicated to corporate office from branch on hourly basis. For this, peer to peer (transactional) replication is considered. But it is avaialable in enterprise version only. Hence we are looking for another option.


#4

You could do this with a scheduled job to extract the data from the branch and load the data into the corporate system. You have to make sure you have a way of identifying your key rows from each system but that shouldn't be too hard to figure out.