Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication with SQL express 2008 R2 Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 8:45 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:22 PM
Points: 22, Visits: 48
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
Post #1554748
Posted Tuesday, March 25, 2014 9:01 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 5:22 PM
Points: 3,064, Visits: 2,676
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



Post #1554752
Posted Tuesday, March 25, 2014 9:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:22 PM
Points: 22, Visits: 48
Thank you for the response Happycat
Post #1554757
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse