Post reply

Merge replication between SQL 2008 Express and SQL Compact

  • November 10, 2014 at 12:02 pm

    #312880

    Hi,

    Is it possible to setup a merge replication using those 2 versions of SQL Server? I want to synchronize a SQL Compact database on a PocketPC with a SQL 2008 R2 Express.

    What is the best way to do it?

    thanks a lot for your time and help

  • November 10, 2014 at 12:08 pm

    #1757524

    Since Express and Compact only support Subscriber access for replication, you'll need a third database that supports publish. both express and compact could then subscribe to the third db

    Gerald Britton, Pluralsight courses

  • November 10, 2014 at 12:12 pm

    #1757526

    You might want to look into synchronization, instead of replication.

    How to: Execute Database Synchronization (SQL Server)

    http://msdn.microsoft.com/en-us/library/dd918848%28v=sql.110%29.aspx


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • November 10, 2014 at 1:02 pm

    #1757541

    Unfortunatly, having a full SQL installation is not an option. So I'll definitly look into Sync service.

    thanks for the help!

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply