locked
Exposing SQL Sever --> SQL Express via WCF/NTier approach RRS feed

Answers

  • you can easily upgrade the project to VS2010, there is nothing specific in VS 2008 or VS 2010 that affects the sample.
    • Marked as answer by xcfrt Thursday, February 10, 2011 3:58 PM
    Thursday, February 10, 2011 2:20 PM

All replies

  • have you looked at this sample? http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762

    you may have to refactor it thought to host the WCF service in IIS.

     

    Thursday, February 10, 2011 1:35 PM
  • Hi, Thanks for the quick response, do you know if there is such a sample for VS2010?

     

    Thursday, February 10, 2011 1:44 PM
  • you can easily upgrade the project to VS2010, there is nothing specific in VS 2008 or VS 2010 that affects the sample.
    • Marked as answer by xcfrt Thursday, February 10, 2011 3:58 PM
    Thursday, February 10, 2011 2:20 PM
  • hi thanks, this indeed is easy to upgrade, for anyone watching see: http://code.msdn.microsoft.com/sync/Thread/View.aspx?ThreadId=3037

    Can I ask can u also utilise sql 2008 tracking in express, as again the example listed above uses the old way with triggers, and the sql tracking example again uses CE as an example?

    Thursday, February 10, 2011 2:31 PM
  • Hi,

    I have been in the same position as you and tried to refactor the sample June mentioned

     http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762 

    However, this proved to be "difficult" - indeed I spent a lot of time reseaching the WCF method, but found no concrete examples with an IIS hosted replication service.

    What we ended up doing was a direct connection (IP  + Port in connection string for the server) but using NoIP hosts to control access through the firewall.  This worked pretty well apart from public WiFi is really locked down - so we used the ssl port to "guarentee" access (since we could replicate from McDonalds - we think that this was good enough!!!).

    Hope this helps!

    Cheers

    Peter

     


    Newbie web developer
    Monday, February 14, 2011 8:18 AM
  • Hi, The only initial issue I had was upgrading the project to VS2010, which simply mean't changing a few refs, but will certainly take into considerations of deploying to IIS, and feedback when we get to that. Thanks One thing would the web service approach mentioned in the link negate the need for direct access?

    I came across this which may help with installing via IIS?: http://www.syncguru.com/projects/SyncServicesDemoWebService.aspx

    Monday, February 14, 2011 11:08 AM