Geeks With Blogs
Vishal Shukla

Finally after 2 weeks I did get chance to publish the second part of my article on Sync Services.

The article is a follow up article to Introduction to ADO .Net Sync and takes a look at how easily we can convert a two Tier Sync application to N tier using WCF services. The ability to sync up your data without connecting to the main database is a great value and opens the door to many complex architecture implementations. There are many examples on sync services online but most of them are in C#, hence here I am just trying to have very basic examples for the VB community.

If you need slides for your own presentation you can get it from my previous blog. In the coming weeks I'll try to post more examples on sync services, and my next target is to convert the 101 sample library from MSDN to VB .net if someone has not already done that.

Posted on Tuesday, October 7, 2008 7:52 AM vb .net | Back to top

Comments on this post: ADO.NET Sync Services in N Tier Architecture

# re: ADO.NET Sync Services in N Tier Architecture
Requesting Gravatar...
Actually my problem is that my client machine have MS-Access or My-SQl

My clients don't have MS-SQL Server.

On server side we have SQL Server.

So now the condition is like that

Client Machine have -> MS-Access Database


Server Machine have -> MS-SQL Database

Now please let me know that in this condition is it possible to sync these
two database.

On MSDN I found that

Sync Services for ADO.NET which is a component of the Microsoft Sync
Framework that enables synchronization of ADO.NET enabled server databases
to client side SQL Server Compact databases.

If it support different kind of database on Server side only not on client
side than this is a problem for me and i need to look another option.

So please help me in this.
Left by goje on Jan 05, 2009 9:00 AM

# re: ADO.NET Sync Services in N Tier Architecture
Requesting Gravatar...
Yes, by default the provider that is provided with sync framework works with SQL Ce on the client side. But you can develop your own provider and in Sync 2.0 they have made the task of developing custom provider lot easy. I know the SQL Ce team has already developed a provider to use SQL Express instead of SQL Ce. By now I think someone must have come out with provider for Access or something else.

on the other noter SQL Ce is free and can be embadded within the application, so it becomes just one of the support library along with other support libraries in your application. You dont need any special license to use SQL ce.
Left by Vishal Shukla on Jan 05, 2009 6:57 PM

# re: ADO.NET Sync Services in N Tier Architecture
Requesting Gravatar...
thx :)
Left by nedemek on Sep 13, 2010 6:41 AM

Your comment:
 (will show your gravatar)

Copyright © Vishal | Powered by: