Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Change tracking SQL 2008 to ado.net db RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    This site: http://www.syncguru.com/Default.aspx shows some excellent example on synchronizing from webservice with mssql backend to a client with an ADO.net db.
    I would like to make use of the new Change tracking feature in MSSql 2008. Is this possible in this case, or does this require MSSql 2008 on both client and server?
    If this is possible, are there any example implementations?

    Thank you!
    • Moved by Hengzhe Li Friday, April 22, 2011 3:23 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Saturday, April 18, 2009 2:44 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Support for SQL 2008 Change Tracking is supported by the Sync Designer in VS 2008 SP1, see this: http://dotnet.org.za/calmyourself/archive/2009/03/25/creating-a-sql-express-change-tracking-based-sync-framework-part-1.aspx
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Sunday, April 19, 2009 8:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    This means only MSSql CE has support for the new change tracking feature? I'm using a sqlite database (because it requires no install on the client).
    Sunday, April 19, 2009 10:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The Change Tracking feature only requires SQL 2008 on the server! SQL Compact (SQL CE) also allows zero install. (Just include some files with your app)
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Sunday, April 19, 2009 3:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Then how does the client keep track of the changes? Or is this automatically created on first time synchronization?

    Btw, the article you mentioned uses FileFactory to host the file but there never is a free slot available.... :(

    Thanks
    Wednesday, April 22, 2009 6:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    On initial sync, change tracking system tables and system columns are added to the SQL Compact database. More info here: http://msdn.microsoft.com/en-us/library/cc714038.aspx (and releated walkthroughs)

    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Wednesday, April 22, 2009 6:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    On initial sync, change tracking system tables and system columns are added to the SQL Compact database. More info here: http://msdn.microsoft.com/en-us/library/cc714038.aspx (and releated walkthroughs)

    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Wednesday, April 22, 2009 6:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you for the info!

    I finally was able to download the demo from the article, I reuploaded it here in case anyone else is interested:

    http://rapidshare.com/files/224511399/ChangeTrackingDemo.rar.html
    Wednesday, April 22, 2009 6:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,

    I have one last question ;)

    When the client database is created on by the sync manager, am I right that it doesn't create the relations between tables like on the server but only primary keys? Or am I missing a setting.

    Thank you
    Thursday, April 23, 2009 5:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You are right, you must add the Foreign Keys manually, for example in the SchemaCreated event.
    Erik Ejlskov Jensen, MCTS: WM App, MCITP: SQL 2008 Dev - http://erikej.blogspot.com Please mark as answer, if this was it.
    Thursday, April 23, 2009 5:59 PM