Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Update .sdf on company desktops Expand / Collapse
Author
Message
Posted Friday, March 25, 2011 8:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 5:42 PM
Points: 1,155, Visits: 549
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.
Post #1084053
Posted Tuesday, March 29, 2011 7:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 5:42 PM
Points: 1,155, Visits: 549
I am thinking of implementing a "Local Data Cache" using Microsoft Synchronization Services for ADO.NET.
Post #1085533
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse