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

Related posts

Comments

April 3. 2008 04:15

Gravatar

udah selesai lom skripting nya ??? eh skripsi

brokencode

April 4. 2008 18:45

Gravatar

Gw juga nyari implementasi ClientSyncProvider untuk DB selain SQL CE, gak nemu. Gw punya skenario sync SQL Server - SQL Server, and MySQL to MySQL. Wlpn masing2 punya fitur replikasi sendiri2, tapi ingin bikin satu untuk semua.

Mudah2an ya ada yg bikin implementasinya untuk DB lain2. Keep posting ya...Good work :)

Andri Yadi

April 10. 2008 02:48

Gravatar

wew, ada bos broken ma mas andri yang lewat, iya nih mas,, lagi nyari implementasinya :D

yitro

Add comment


(Will show your Gravatar icon)  

  Country flag




Live preview

August 21. 2008 00:03

Gravatar