Discussion Groups

Hi,

Now database is working fine.One query about the DB Synchronization.

How to Sync the Data between Microsoft Access database or SQL Database (.mdf) on  desktop and  SQL Compact Edition database(.sdf) on a device.

When i cradle my device to Desktop I want to Auto Update the Desktop Database with Device Database.

Thanks ,

Ani

Ani,

Have you considered Using Remote Data Access (RDA) ?

In case it helps/inspires you, let me bring this Handling Connection Notification post to your attention.

Kind regards,
Jacques

Hi Jacques,

can you please tell me how to implement RDA in my Smart device application.

If you have any sample code can you please share it ?

Thanks,

Ani

Good morning Ani,

For your information Microsoft offers a suite of SQL Server Compact 3.5 How-to Tutorials.

Regards,
Jacques

Hi Anirudda / Jacques.

In the RDA link Jacques presents is the link to Microsoft Synchronization Services in ADO.NET for MS-SQL.

http://msdn.microsoft.com/en-us/library/bb725998(v=sql.105).aspx 

This is one of the better "Automated" methods to synchronize data between an HHT, and an MS-SQL databases in the back end.

But it is fairly complex, and requires a comprehensive suite of services to be published in the Back End. Things like IIS, Replication Services and other .NET Frameworks need to be installed and configured.

Alternately, if you know what got modified on the HHT session and know what that would require to update in the Back End, then the SQL Server client can be used to connect to the back-end and update accordingly. But keep in mind that will require development of methods to both store the data locally on the HHT as well as knowing what to update in the Back-End as well as knowing what to do if there is a subtle change in the back-end data.

-sean

Hi Sean ,

I have an queries about SQL CE database ..

How to connect  Sql CE database of device from my winodws application ?

My device is connected Using USB to Desktop.

And How to copy the file from device to desktop ?

Thanks & Regards,

Aniruddha

Hi Anirudda.

I will now go into Full "Academic" mode and ask you to do the following:

Really the choice is yours to make, you need to investigate and decide on what path you wish to take.

MSDN is your primary resource to development using Microsoft Developer solutions for Microsoft Windows device / systems development.

I alluded to that in my response about RDA -- I will repeat the link and you can browse from there to investigate your solutions:

Here: http://msdn.microsoft.com/en-us/library/bb725998(v=sql.105).aspx

Please click around in MSDN, there is a TREMENDOUS amount of content that one can investigate.  Further there are outside sites like www.codeproject.com, and www.connectionstrings.com that are fablulous resources for development and SQL methods you have already asked Jacques and I about.

I also created a Blog entry on topics such as this that is worth reading as well as looking at an excellent comment regarding a Specific Vendors platform for doing the same.

Here: http://community.psion.com/blog/b/weblog/archive/2012/04/23/moving-data-a-developers-introduction.aspx

In this blog I explain options that answer your question.

But your question Veered from the origional premise of this thread, and I feel that when buried as a tangental topic, the purpose is lost. 

MS-SQL is mostly a Microsoft topic and I propose that you ask SQL-Like questions to the MSDN social networking  site:

Here: http://social.msdn.microsoft.com/Forums/

Since that is a more relevant location to ask questions such as these.

Now, back to your study, and code.

-sean