Replication with SQL express 2008 R2

• C-kweldude

  Old Hand

  Points: 312

  More actions

  March 25, 2014 at 8:45 pm

  #305646

  Hi Guys

  I want to sync 2 databases both running on SQL express 2008 R2

  Is this possible or do you need full SQL to do this?

  Thanks in advance

  A

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  March 25, 2014 at 9:01 pm

  #1700118

  SQL 2008 R2 Express can only be a subscriber (have a look at http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).ASPX)

  So, you will need something like Standard Edition to be able to replication to SQL 2008 R2 Express

• C-kweldude

  Old Hand

  Points: 312

  More actions

  March 25, 2014 at 9:41 pm

  #1700122

  Thank you for the response Happycat:-)