7 comments on “Enterprise Data Synchronization with Microsoft SQL Server 2008 and SQL Server Compact 3.5 Mobile Merge Replication

  1. Hi Rob,

    I’m a happy owner of your previous data sync book with SQL2005 and CE3.1. I have now bought this newwe version of the book to be in line with SQL2008/CE3.5.

    I was wondering if you would be able to share with me the load testing tool that you use for the scale-out testing of merge replication? I am currently embarking on a project to development a new system using CE3.5 on CF2.0, and as part of this I need to do some POC testing in regards to load/scale on our hardware. The test tool that you use looks absolutely fit for this purpose, and try as much as I can, I can’t find anything as useful in the community.

    Any help you could give me would be appreciated.

    Thanks,

    Mike.

  2. Great book.

    A thought –
    Server Agent – does fit neatly into the magazine metaphor:
    Associated Press feeding and receiving input from many reporters to refine and track an evolving story – seems to fit nicely.
    Editor acting as clearing house, channels to push details through, protocols for reconciling details – hey .. maybe :-) .

    By the way – great authorship.
    Concepts and practical application instead of a world of details,
    gets to thinking – solutions.

    Thanks

  3. Rob, I have your book and have configured everything perfectly from start to finish… well not perfectly, there is still something wrong. I get a password error everytime I try to initialize the Contoso Mobile Database from the Windows 6.0 Visual Studio emulator. I have more information and screenshots. Could you help me please? Its probably something simple but I’ve been struggling with it for hours. My email is in the required section. I’m sorry to bother you with this, but you are the only person I have to turn to! Thank You.

  4. I figured I should give you all the info here, to avoid having to email back and forth. Thank you SO MUCH for your time!!!

    My setup is ALL on my laptop, with SQL Server 2008, IIS, SQL CE with Tools installed, Visual Studio 2008, and everything is configured “per the book” with my SQLCE Server Agent diag & stats pages work fine. ContosoBottlingPub is ready and waiting for a subscriber!

    The problem is with the Subscriber. I’m using Visual Studio 2008, I’m running your app (which is a great tool!), it comes up, I configure my Login Credentials using the Generator, and copy the replcred.bin file to all of the directories on my HD under C:\ContosoMobile\.
    NOTE, the app says to copy it to the application folder of the Mobile Device. How do I do that? I’m guessing putting it in the C:\ContosoMobile directory should do the trick? But this could be the problem.

    What happens is, when I launch the ContosoMobile app, I get an error “Could not initialize the Contoso Mobile database, please send the app tracefile to support…”.

    1) When I dig further I’m seeing an ISQLW Error: Incorrect Password. The DB Notes state
    Error: DB_SEC_E_AUTH_FAILED. The specified password does not match the database password.
    Param.3: \Program Files\ContosoMobile\ContosoMobile.sdf

    NOTE, I can’t see the .sdf anywhere on the Device. Is it hidden, or just not getting there?

    2) I also see an output file stating “Error Code 80072EE7, A request to send data to the computer running IIS has failed. For more information, see HRESULT.” (no idea where HRESULT is.)

    3) Am I not putting the replcred.bin file in the right place? I don’t see it on the HH, but it could be a hidden file type.

    4) Where is the tracefile? I see a beautifully written TraceFile.cs, but can’t find a path to where it is being written to.

    Help Pleeease!

    Oh, here is my Config File, “G5HYRK1\G5HYRK12008″ being the SQL Server 2008 Instance where the ContosoBottling DB is installed, as well as the Distributor and Publisher.

    Thank you sooo much for any advice!!

  5. Okay, I’m officially pushing my luck with you guys. BUT… I noticed the XML didn’t copy to the previous Comments, so re-pasting it here (minus the leading
    configuation>
    appSettings key=”AUTO_SYNC_INTERVAL_DAYS” value=”2″/>
    appSettings key=”CONNECTION_CHECK_URL” value=”http://www.microsoft.com”/>
    appSettings key=”REPLICATION_DISTRIBUTOR” value=”G5HYRK1\G5HYRK12008″/>
    appSettings key=”REPLICATION_PUBLICATION” value=”ContosoBottlingPub”/>
    appSettings key=”REPLICATION_PUBLISHER” value=”G5HYRK1\G5HYRK12008″/>
    appSettings key=”REPLICATION_PUBLISHER_DB” value=”ContosoBottling”/>
    appSettings key=”REPLICATION_SUBSCRIBER” value=”Subscriber”/>
    appSettings key=”REPLICATION_URL” value=”http://G5HYRK1/ssce/sqlcesa35.dll”/>
    /configuation>

  6. Nevermind, I’m sorry about bugging you guys. I finally noticed in your Handset Code Snippet (in the book) that you have hardcoded your password in the app. Then I found it in the code and see it is encrypted. (sorry, I should have known your login data wasn’t a suggestion, it was literal!) So I wrote my own app and although I’m still quite not there yet I’m very close.

    Your book is great, Thanks so much for writing it! I hope to have this hurdle crossed today.

    Best Wishes!!
    \Becky

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>