Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

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

    • Marked as answer by Yunwen Bai 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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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