locked
how to SYNC? RRS feed

  • Question

  • hi,

    Task: I want to sync Table A from SQL  server 2005  to sql server express 2005 using Sync framework.

    thats it.

    PLease provide
    1.some simple steps
    or
    2.Links to do Task


    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 11:33 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Thursday, September 3, 2009 11:24 AM

Answers

  • Hi,

    mmmm...

    Task :

    type 2 keywords in google or the search-board functionality :-)


    1. Start here: http://msdn.microsoft.com/de-de/sync/default%28en-us%29.aspx

    2. Have especially a look at the right box "Code Gallery Samples".

    3. http://www.syncguru.com/Projects.aspx maybe also helps, but the examples are a bit old

    4. define the column types of your CHANGE_DATE, CREATE_DATE columns as timestamps, not as datetime like it is provided in various examples.
    Otherwise you will run into trouble if you want to use sync-batching!

    5. Use uniqueidentifier instead of int-Primary Keys if possible.



    Regards,

    Martin
    • Proposed as answer by macap Thursday, September 3, 2009 1:18 PM
    • Marked as answer by Sean_KelleyModerator Friday, September 4, 2009 4:31 PM
    Thursday, September 3, 2009 1:18 PM

All replies

  • Hi,

    mmmm...

    Task :

    type 2 keywords in google or the search-board functionality :-)


    1. Start here: http://msdn.microsoft.com/de-de/sync/default%28en-us%29.aspx

    2. Have especially a look at the right box "Code Gallery Samples".

    3. http://www.syncguru.com/Projects.aspx maybe also helps, but the examples are a bit old

    4. define the column types of your CHANGE_DATE, CREATE_DATE columns as timestamps, not as datetime like it is provided in various examples.
    Otherwise you will run into trouble if you want to use sync-batching!

    5. Use uniqueidentifier instead of int-Primary Keys if possible.



    Regards,

    Martin
    • Proposed as answer by macap Thursday, September 3, 2009 1:18 PM
    • Marked as answer by Sean_KelleyModerator Friday, September 4, 2009 4:31 PM
    Thursday, September 3, 2009 1:18 PM
  • Hi,

    mmmm...

    Task :

    type 2 keywords in google or the search-board functionality :-)


    1. Start here: http://msdn.microsoft.com/de-de/sync/default%28en-us%29.aspx

    2. Have especially a look at the right box "Code Gallery Samples".

    3. http://www.syncguru.com/Projects.aspx maybe also helps, but the examples are a bit old

    4. define the column types of your CHANGE_DATE, CREATE_DATE columns as timestamps, not as datetime like it is provided in various examples.
    Otherwise you will run into trouble if you want to use sync-batching!

    5. Use uniqueidentifier instead of int-Primary Keys if possible.



    Regards,

    Martin
    hi,

    Thanks for answering
    In point 4,can you give an example 

    by the way
    what is meaning of  "mmmm..."




    Thanks, Bharathi
    Friday, September 4, 2009 10:37 AM