C# .NET - Sync .sdf database from and to local server

Asked By Ranjan Dissanayake
10-Feb-12 06:21 AM
Hi,

Im developing a windows mobile application.due to insufficient memory in PDA, I need to use a Storage Card and store the SQL Server Compact file (.sdf) in the storage card and access it from the PDA. on the other hand i need to sync this database to a local server. 

Please help on this .
  Danasegarane Arunachalam replied to Ranjan Dissanayake
10-Feb-12 08:15 PM
Have look at the Smart Client Application Development from MSDN

And the explains

    Create a new Smart Device application.

    Add a new Window Communication Foundation (WCF) Service Library which serves as a middle tier between the local database cache and the remote database.
    NoteNote:

    The middle tier service library is required because Synchronization Services for ADO.NET (Devices) does not support direct 2-tier synchronization.

    Add a new Local Database Cache to the project.

    Configure synchronization settings.

    Configure and start the WCF service.

    Add synchronization functionality to your device application.

    Test the application.


http://msdn.microsoft.com/en-us/library/cc488004%28v=vs.90%29.aspx


And also think about Synchronization in data services in SQL Server





http://keithelder.net/2007/09/23/Sync-Services-for-SQL-Server-Compact-Edition-3.5-in-Visual/
  Anoop S replied to Ranjan Dissanayake
11-Feb-12 05:17 AM
make sure you have installed the sql server ce correctly  and make sure it's install on memory phone
and the data source should be like

Data Source='\storage card\aaa.sdf'
  kalpana aparnathi replied to Ranjan Dissanayake
11-Feb-12 06:05 AM
hi,

I would suggest that you utilize SQL Server Express.  It's a fairly light running application, it will generally run on what Windows 7 will run on.  Also with SQL Server Express, you can do something called Replication.  This is an automated process of updating a database to a stand set by a single DB. 


The only problem  when the database doesn't update for more than a week, this is generally because the computer is off for a while.  This issue is also one that  created  for several technical reasons. 

Also, if you are building this as a web application, I would suggest using a client type of application.  Some like WPF or Win Forms. 


Thanks,

  Somesh Yadav replied to Ranjan Dissanayake
13-Feb-12 07:32 AM

Hi,
I have never been a big fan of utilizing .sdf files to run an application.  I would suggest that you utilize SQL Server Express.  It's a fairly light running application, it will generally run on what Windows 7 will run on.  Also with SQL Server Express, you can do something called Replication.  This is an automated process of updating a database to a stand set by a single DB. 

I work for a large corpation with hundreds of client machines running an application that needs to have the Stand Alone ability, this is what we use.  The only problem that we have is when the database doesn't update for more than a week, this is generally because the computer is off for a while.  This issue is also one that we have created for ourselves for several technical reasons. 

Also, if you are building this as a web application, I would suggest using a client type of application.  Some like WPF or Win Forms. 

Create New Account
help
some basic examples for wcf. neecd ur suggestions with examples regards gopal.s Introduction. Windows Communication Foundation (WCF) is Microsoft's unified programming model for building service-oriented applications. It enables developers on layers. See on Figure 1. http: / / msdn.microsoft.com / en-us / netframework / dd939784 Windows Communication Foundation (WCF) is an extension of the .NET framework to build and run connected systems. Windows Communication Foundation provides a unified framework for building secure and reliable transacted Web services. Windows Communication Foundation combines and extends the capabilities of Distributed Systems, Microsoft .NET Remoting, Web Services, and Web
and WCF if any Examples, Tutorials for simply identify. . pls help me. . Hi The Windows Communication Foundation (WCF) represents one of three main pillars of .NET 3.x. These three specific highly leverage able technologies include Windows Workflow Foundation, Windows Presentation Foundation, and Windows Communication Foundation. WCF Endpoints Endpoints define the originators and recipients of WCF communications. Microsoft has come up return composite; } } follow http: / / srinutamada1.wordpress.com / 2008 / 09 / 05 / aspnet-and-wcf / Windows Presentation Foundation (WPF) is a next-generation presentation system for building Windows client applications with visually stunning WPF application Now, let's take a look at the code for the WPF version: <Window xmlns = " http: / / schemas.microsoft.com / winfx / 2006 / xaml / presentation " xmlns:x = " http: / / schemas.microsoft.com
wcf what is wcf? simple example of wcf HI WCF = Windows Communication Foundation A communication-oriented set of APIs and a "runtime" inside .NET to make two (or more) systems basically replaces ASMX (ASP.NET web services), .NET remoting (object remoting) and a few other communication-related API's and products in the .NET space. alt text Example : Service definition 1 get-started-with-wcf.aspx http: / / weblogs.asp.net / joestagner / archive / 2008 / 03 / 15 / windows-communication-foundation-65-links-to-make-you-an-expert.aspx http: / / stackoverflow.com / questions / 2577744 / what-is-wcf-in-net Introduction to WCF Windows Communication Foundation (Code named Indigo) is a programming platform and runtime system for building, configuring and deploying
What Should. . . . . . What should I use message security in WCF? Transport security in Windows Communication Foundation (WCF) depends on the binding selected . The transport that the binding implements determines the actual us / library / ff649839.aspx Here you will get WCF related questions and answers. hi, Windows Communication Foundation (WCF) has two major modes for providing security ( Transport and Message ) and a third mode aspects. This enables some scenarios that are not possible when transport security is used. Windows Communication Foundation (WCF) has two major modes for providing security ( Transport and Message ) and a third mode end security. A secure transport, such as Secure Sockets Layer (SSL) works only when the communication is point-to-point. If the message is routed to one or more SOAP intermediaries concepts. This can improve the interoperability, for example, when HTTPS is used to secure the communication. Generally improved performance. Hardware accelerators are available. Streaming is possible. Transport security has the following
Windows Communication Foundation FAQ quick starter Part 2 This section will cover WCF (Windows Communication Foundation FAQ quick starter Part 2) Windows Communication Foundation FAQ quick starter Part 2 Introduction Can you explain duplex contracts in WCF? How can com . I am sure every one needs improvements. Enjoy… To view Part 1 of Windows Communication Foundation FAQ quick starter click the following link Part 1 :- http: / / www.eggheadcafe.com / tutorials / aspnet