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.