Merge Replication - is it possible to have a Publisher as 32 Bit SQL Server and Subscriber as a 64 Bit SQL Server.

• tsharp-804446

  Valued Member

  Points: 65

  More actions

  November 10, 2013 at 1:47 pm

  #282241

  We currently have 1 publisher and 1 subscriber for our Merge replication setup.

  We currently have SQL Server 2008 standard edition 32-bit instance setup for our publication.

  Can we install SQL Server 2008 web edition 64-bit instance for our subscriber? My concern is the publisher is on 32-bit instance and the subscriber will be on a 64-bit instance of SQL Server.

  Thanks,

  Toni

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 11, 2013 at 1:46 am

  #1665381

  There's no problem with that setup.

  Replication distributes logical contents of the database, regardless of the bit-ness of publisher and subscriber.

  -- Gianluca Sartori