The Problem Solver

Tell me and I will forget
Show me and I will remember
Involve me and I will understand
- Confucius -

Google Ads

This Blog

Syndication

Search

Tags

News





  • View Maurice De Beijer's profile on LinkedIn

Community

Email Notifications

Explore

Archives

Sync Services for ADO.NET and SQL Express on the client

Earlier this week at the SDC conference I gave a presentation about the Sync Services for ADO.NET. Some attendees where pretty exited about this new possibility to sync data between a local data cache and some sever. Especially that they could use pretty much any database on the server as long as there is a managed provider. Now on the client side people where somewhat less thrilled that the only option seemed to be SQLce. In fact only a single person in the audience was currently using SQLce. Now I think SQLce is a very interesting product and could be used as a replacement for SQL Express in a fair number of applications so I suggest you take a look at it. However the good news is that Microsoft is planning on releasing a sample local provider for SQL Express on the client when Visual Studio 2008, Sync Services and SQL Server Compact are released.

Still I highly recommend taking a good look at SQLce as it is more that adequate in quite a few cases and it can make life a lot easier Smile

Enjoy!

 

Published Thu, Sep 20 2007 11:40 by Maurice
Filed under: , , ,

Comments

# re: Sync Services for ADO.NET and SQL Express on the client@ Monday, September 24, 2007 3:12 PM

http://www.ourselves.nl/?p=11

# re: Sync Services for ADO.NET and SQL Express on the client@ Wednesday, March 12, 2008 4:11 PM

Has SQL Express Client Provider been released yet?  

SQL CE is pretty much useless for our needs as we need a robust database on the client.

mail -at- jaypatel/./com

by Jay Patel

# re: Sync Services for ADO.NET and SQL Express on the client@ Thursday, April 10, 2008 9:36 AM

Yes Patel, I agree. Even you can't implement role based security in SQL CE

by Danial

# for test my car@ Friday, July 18, 2008 3:29 AM

this topic for test car

by Annermjex

# test time mashine@ Wednesday, July 30, 2008 1:23 AM

tests time mashine

by gjoppers

# re: Sync Services for ADO.NET and SQL Express on the client@ Thursday, January 29, 2009 8:32 AM

Same issue here from last 3-4 months, just waiting on a project to go live with the SQL Express sync support. We have developed our project half way through based on the sql express sync sample but getting stuck with some problem issues which I am sure would get resolved with the final release from MS for sql express sync support.

Pls do give an update as to when this would be available so that we could plan accordingly.

many thanks

by Rajesh