side by side of my sides
cannot describe more..

Between MS Sync Framework for ADO.NET and SQLServer2005 Merge Replication, which tech will met my project? or both of them?

March 16, 2008 13:12 by admin

In 48 hours ago, i had explored about sychronizing ADO.NET entity using MS Sync Framework v1.0 (after updated its version from CTP1 to CTP2, MSF for ADO.net itself currently have v2.0). MSF?? What is that? That is - A Unified Synchronize framework, a comprehensive synchronization platform that provide synchronizing service for File System and Occasionally Connected Application (OCA) using ADO.NET, enabling collaboration and offline for applications, services and devices with support for any data type, any data store, any transfer protocol, and network topology. (more..)

So, it is about my current project to synchronize the data between regional and center office which the two using SQL Server 2005 as backend DBMS. When tried the sample application using that framework, i thinked i would be nice if i could implement this framework to my project, the sample demo about sync data between SQL Server 2005 as a server and SQL CE 3.5 on handheld device(Windows Mobile) as a client. After coded for MyServerSyncProvider ( inherit from DbServerSyncProvider, a provider abstract class which can handle sync query to many DBMS supported by ADO.NET) so next i had to do was instantiated a client sync provider for SQL Server, unfortunately MSF 1.0 CTP 2 didn't support any implementation for SQL Server and other DBMS except SQL CE 3.5 (SqlCeClientSyncProvider class : ClientSyncProvider). Then i tried to made my own implementation for SQL Server from ClientSyncProvider class, searched for documentation, again, there was no documentation about 'how to' yet. Browsed the forum and blog about MSF, "There is no implementation yet for client sync provider other than SQL Ce" stated by Liam Cavanagh (someone behind this framework). He also stated that his team still struggle a bit to make samples to implement SqlServer Client Sync Provider and of course the documentation... Well, I'll wait for the release (had subscribe the alarm to my LiveMessenger )for the news, haha~ ..

Back to my current project, so this morning i have been exploring about SQL Server 2005 Merge replication that match for my project scenario which is Integrating Data from Multiple Sites (client).. For now, SQL Sever 2005 Merge Replication is the winner to live beside my project^^.. Hope this 'girl' will help my project to resolve the problem and ready to delivery, next 2 days.. whooa.. Ganbatte!  UpSSs.. how pity the destiny of MSF, umm,, not at all,, i'll review it later if the nu rilis has published..

Apakah my project akhirnya akan ber'poligami' jg dengan MSF ??? liat tar deh,,, takutnya jadi bingung tar kek si Fahri bin Abdillah bingung menghidupi antara Maria Girgis dan  Aisha secara ADIL.. hehe, qo malah nyambung ke filmnya Ayat-Ayat Cinta .. uda pada nonton lom? nonton dunk, nontonnya di bioskop yak, jgn beli bajakan loh biar mas hanung bramantio bisa semangat bikin film yang keren lagi... ckckck(jayuz mode* on)


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5