none
What are requiements of runing sync in server and local? RRS feed

  • Question

  • What are requiements of runing sync in server and local? Such as OS, SQL server version in remote and local.
    Wednesday, March 3, 2010 9:47 PM

Answers

All replies

  • If you are referring to running the Server and Local components for the Local Cache Database in visual studio, the answer is not OS Dependant but is tied to a proper Database provider.

    You can use any ADO.NET database providers for both client and server.

    In my environment I use SQL Server 2005 for the server component and SQL CE 3.5 SP1 for the Client (local database cache).

    Others have used SQL Express for the client.  you can theoretically use any ADO.NET database provider for either Server / Client.

    Edit: If you are 32/64 bit you must have the appropriate DLL installed for the ADO.NET Provider and the application running in MSIL or target for the correct framework.

    When using different ADO.NET providers for Client / Server please be aware that data type conversion can and do take place.

    Example: SQL CE varbinary(max) is not supported and is translated to the image data type
    • Proposed as answer by Richard_Y Thursday, March 4, 2010 6:19 PM
    Wednesday, March 3, 2010 10:24 PM
  • Hello aspfun,

    If you are asking about system requirement, please take a look at Sync Framework Hardward and Software Requirement:

    http://msdn.microsoft.com/en-us/library/cc761704(SQL.105).aspx

    FAQ:

    http://msdn.microsoft.com/en-us/sync/bb906054.aspx

    Thanks,

    Patrick
    Wednesday, March 3, 2010 10:50 PM