Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)

Discussion in 'microsoft.public.sqlserver.replication' started by Tim Ford, Feb 7, 2008.

  1. Tim Ford

    Tim Ford Guest

    Hi All,



    I need a little clarification and was wondering if anyone can point me in
    the direction of this.



    Previously we were running MSDE on a client machine and SQL Server 2000 at
    Head Office running Merge Replication. In our application (VB6) we were
    running the Merge ActiveX Control to manage the replication process, however
    some of our clients are moving to Vista and I understand that MSDE is no
    longer supported on Vista.



    So what we would like to do is install Sql Express on the client machine
    running Vista. Can anyone confirm if Sql Express can connect to a Sql Server
    2000 publisher and process merge replication. I understand that Enterprise
    Manager can't connect to Sql Express which is fine, We don't require any
    agents to be run as this can be controlled via the VB6 application either
    running the Merge ActiveX Control or running a COM enabled control with RMO.



    If anyone can point me in the right direction that would be great.



    Thanks, Tim.
     
    Tim Ford, Feb 7, 2008
    #1
    1. Advertisements

  2. No, the publisher must also be SQL 2005 Workgroup edition or above.
     
    Hilary Cotter, Feb 7, 2008
    #2
    1. Advertisements

  3. Tim Ford

    Tim Ford Guest

    Hi Hilary,

    Thanks for getting back to me, so even if i change the compatability level
    of sql express to 80, it still wouldn't be able to connect and replicate a
    pull subscription from sql server 2000?

    Thanks, Tim.

    No, the publisher must also be SQL 2005 Workgroup edition or above.
     
    Tim Ford, Feb 7, 2008
    #3
  4. Exactly!

     
    Hilary Cotter, Feb 7, 2008
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.