none
Sync data between SQL Server 2008 to SQL Server CE RRS feed

  • Question

  • Hi,
    I want to build a process to sync the Data from SQL Server 2008 R2 to SQL Server CE
    Found some basic useful information from 


    So, I want to create a flow to sync all the data to SQL CE and let the application to choose the SQL CE if its in Offline mode.

    I also found using "Sync Framework Database Synchronization" is the only solution to achieve this easily.Correct me if wrong and pls lemme know if any other productive and effective ways for this.
    "
    Please help me out giving some links to articles to achieve my task.

    Thanks,
    Varun




    varun gvk
    Wednesday, January 26, 2011 8:46 PM

Answers

  • You can see an example of how to do this in the Database Sync - SQL server and SQL Compact 2-Tier sample here: http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422.

     

    This sample installed in your computer if you install the Microsoft Synchronization Framework 2.1 SDK, and can be found under [PROGRAM FILES]\Microsoft SDKs\Microsoft Sync Framework\2.1\Samples\SharingAppDemo-CEProviderEndToEnd

     

    Maria del Mar Alvarez Rohena Microsoft Sync Framework
    Wednesday, February 2, 2011 1:20 AM

All replies

  • Sync Fx installation comes with an offline documentation, just look up the tutorials under Synchronizing Databases->Database Synchronization Scenarios

    • Marked as answer by Yunwen BaiModerator Thursday, January 27, 2011 8:14 PM
    • Unmarked as answer by varun gvk Wednesday, February 2, 2011 8:47 PM
    Thursday, January 27, 2011 2:38 PM
    Moderator
  • You can see an example of how to do this in the Database Sync - SQL server and SQL Compact 2-Tier sample here: http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422.

     

    This sample installed in your computer if you install the Microsoft Synchronization Framework 2.1 SDK, and can be found under [PROGRAM FILES]\Microsoft SDKs\Microsoft Sync Framework\2.1\Samples\SharingAppDemo-CEProviderEndToEnd

     

    Maria del Mar Alvarez Rohena Microsoft Sync Framework
    Wednesday, February 2, 2011 1:20 AM
  • After spending some handsome time in learning SyncFramework, I found that using LocalDatabaseCache is the easiest one to opt for.

     

    Please go through the following link:

    http://www.vitalygorn.com/blog/post/2008/01/05/Microsoft-Sync-Framework-Support-in-Visual-Studio-2008.aspx

     

    Mark as answered if this is helpful.

     

    Thanks,

    Vaun Gvk


    varun gvk
    Thursday, February 3, 2011 5:18 PM