Update .sdf on company desktops

  • Erin.

    SSCertifiable

    Points: 5237

    We have a new vendor that uses SQL Compact 3.5 to query four tables within their application. The data is relatively small and all fields are data type nvarchar. This data resides in a .sdf on every desktop within the company. What is the best way to update this data each day? I would like the data to pull from the server rather than push from the server. I would prefer the pull so when a new desktop is created in the company the pull technique can be created then. Rather than adding to the server everytime a new desktop is created on the network.

    Thanks for you help.

  • Erin.

    SSCertifiable

    Points: 5237

    I am thinking of implementing a "Local Data Cache" using Microsoft Synchronization Services for ADO.NET.

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

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