Update .sdf on company desktops

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » Update .sdf on company desktops

Update .sdf on company desktops

Rate Topic

Display Mode

Topic Options

Author

Message

Erin.

Posted Friday, March 25, 2011 8:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:43 AM
Points: 1,151, Visits: 531

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

Erin.

Posted Tuesday, March 29, 2011 7:54 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:43 AM
Points: 1,151, Visits: 531

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

Post #1085533

« Prev Topic | Next Topic »

Permissions