Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Do I have to use SQL Compact with Sync? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Very basic question.....
    I'm trying to decipher if Sync makes sence for my situation. We have roaming client-side .net apps that need to off load sql database changes to Sql Server. We can't have Sql Server Compact running on the client-side due the limitations of Sql Server Compact.

    Can we run something other than SQL Compact on the client-side and still use Sync?

    Monday, May 17, 2010 3:45 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You can have SQL Server as both server and client databases for your scenario. Please take a look of the SQL Server to SQL Server Express sample: https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762.

    Thanks,

    Dong 

    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 7:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Is this posible with Sql Server 2005 and VS 2005?

    Thanks!

    Monday, May 17, 2010 9:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    SQL Server 2005 is supported. The current sample project is built with VS 2008 because of the WCF built-in supports. You can use VS2005 to write your own solution, but you may not be able to load the exact sample project in VS2005. Instead, you can create new project in VS2005 and move source files into it.

    Thanks,
    Dong

    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 9:29 PM