.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Sql Ce in a szenario with ASP.NET and synchronisation

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

Hi all,

I'm checking a szenario for a project which should satisfy the following two requirements

- a Silverlight based UI running on a local machine using data stored in a local database
- a sync function which synchronizes locally added data to a server-based database (via internet)

Is it possible to use Sql Compact for this szenario?
As far as I know the Silverlight App needs Sql Ce 4 because of its ASP.NET Web App Support.
But is there a way to sync a Sql Ce 4.0 with a Sql Server?

Or am I on a wrong way??

Best regards

View Complete Post

More Related Resource Links

Profile User Synchronisation Service

Hi, I have a problem to open Profile User Synchronisation. It doesn' work, I tried to verify this problem by opening services.msc but It show an error when I try to restart the service : Error 1068 The service or the groupe of dependency can't be restarted.   Thanks

User Profile Synchronisation

Hi all, I need to configure User Profile Synchronisation and I only want to synchronize 300 accounts from the 5000 in Active Directory. These users are scattered all over the AD tree and are nested deep into many nodes. When I start setting up the connection, I click the Populate Container node. I can go a number of nodes deep but I'm not able to see/select users in that node. I don't want to select the complete node because 60% of the accounts in that node does not need to be synchronized. Is there a way to simply type in the login name of a user and add it to the synchronization process? Thanks in advance for your time. Steph Kaiser  

Issue on MS Access linked to SQL data replica after synchronisation


We have a MS Access front end linked to an SQL 2005 database with around 200 tables. The database is setup with merge replication and an issue occurs on the publication database but after the data is synchronised. If a user tries to add a new record they get an error with #deleted record when trying to add new data into the tables from MS Access. After this first prompt for the deleted record the users can then operate as normal with no error messages and the system functions as normal. Another issue that occurs, but again only just after the data is synchronised, is that if the user requests to view all of the jobs for a particular client the very first time the search is performed a random un-related job is shown not the expected results, if the search is run again then it will funciton correctly until the next synchronisation is run.

Our tables have Unique IDs with automatic indentity and GUIDs. We have exactly the same solutions working on MSDE and SQL 2000 and there is no such problem on these system.

Any ideas would be most appreciated.


user profile synchronisation on subdomain

Hi, I'm following the 'Rational Guide to implementing Sharepoint server 2010 UPS' of Spencer Harbar and I have the following concerns: First of all, we have a native 2003 forest with 2 subdomains. All our users and application servers are located in the subdomain. 1:Do I setup the UPS connection to the forest or can I also specify the subdomain in the connection settings section? (sharepointservers and users are located in this subdomain) 2: A:Do I give delegation of control on the subdomain level or on the root domain level to the SPUPS account? B:Will this impact my current delegations set on several OU's?. (Append or overwrite) thanks in advance

Document Library Synchronisation with Outlook 2007 - Subfolder Synchronisation Fails


Hi there!

We have a document library of about 2 GB (approx. 3000 files) with nested subfolders (migrated to MOSS 2007 from a fileserver). Generally we have no problem to take all files offline (after selecting "Mark to download" in Outlook 2007). Also new files are taken offline without any problems automatically.

But when we create a new subfolder within the document library those new subfolders and files are not synced to Outlook. The users then have to manually right-click on the document library in Outlook and select "Mark to download" again. After a click on "Send/Receive" all the new folders and files are synced.

Is there a way to make sure, that also new subfolders are synced automatically?

Thanks in advance!




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend