Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SyncSvcUtil: IncludeAllCoumns=false has no effect RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    While trying to codegen a syncscope definition which explicitly defines a subset of <SyncColumns> i have found out that the IncludeAllColumns attribute of the <SyncTable> element has no effect: the generated entities have all columns of the table.

    This also prevents me from excluding bit columns from the existing table during syncscope generation. :-(

    Thursday, July 1, 2010 2:37 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Both issues are known bugs. We do have a fix for it and are going through the test phase before we could release this as a hotfix. ETA is early next week.

     

    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Proposed as answer by mjayaram Thursday, July 1, 2010 4:43 PM
    • Marked as answer by M.Bi Friday, July 2, 2010 6:04 AM
    Thursday, July 1, 2010 4:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd like to specify just certain columns.  I also can not tell what the syntax would be. 

    According to the documentation it should be something like this:

     <SyncTables>
 <SyncTable Name="Attendees" GlobalName="Attendees" IncludeAllColumns="false">
  <SyncColumns>
  <SyncColumn Name="Id" GlobalName="Id" IsPrimaryKey="true" IsNullable="false" SqlType="uniqueidentifier" />
    
  <SyncColumn Name="UserFirstName" GlobalName="UserFirstName" SqlType="varchar" />
    
  <SyncColumn Name="UserLastName" GlobalName="UserLastName" SqlType="varchar" />
    
  </SyncColumns>
    
 </SyncTable> 
 </SyncTables>

    Please refer to the chapter "SyncSvc Util Documentation / Server Scope Provisioning" in the SyncFX 3.0 CTP help file for a complete schema and description.

    Also, I'm having trouble understanding what [side] is.  Is that a schema?

    FilterClause="[side].UserID = @UserID" >

    This is an alias used in the sync related stored procedures added during provisioning the database. These procedures are based on this pattern:

    ... FROM [MainTable] [base] RIGHT JOIN [MainTable_tracking] [side] ...

    Please refer to the procedure Tag_selectchanges from the listdb sample.

    HTH

    • Edited by M.Bi Wednesday, July 7, 2010 6:43 AM Formatting fix
    • Marked as answer by mjayaram Monday, July 12, 2010 4:53 AM
    Wednesday, July 7, 2010 6:25 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Both issues are known bugs. We do have a fix for it and are going through the test phase before we could release this as a hotfix. ETA is early next week.

     

    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    • Proposed as answer by mjayaram Thursday, July 1, 2010 4:43 PM
    • Marked as answer by M.Bi Friday, July 2, 2010 6:04 AM
    Thursday, July 1, 2010 4:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd like to get the hotfix also.  I'd like to specify just certain columns.  I also can not tell what the syntax would be.  I'm guessing the following but it did not parse.

     <SyncTables>
 <SyncTable Name="Attendees" GlobalName="Attendees" IncludeAllColumns="false" SyncColumns="[Id,UserFirstName,UserLastName]" />
</SyncTables>

    Also, I'm having trouble understanding what [side] is.  Is that a schema?

    FilterClause="[side].UserID = @UserID" >
    Thanks
    Peter Kellner http://peterkellner.net Microsoft MVP • ASPInsider
    Tuesday, July 6, 2010 11:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'd like to specify just certain columns.  I also can not tell what the syntax would be. 

    According to the documentation it should be something like this:

     <SyncTables>
 <SyncTable Name="Attendees" GlobalName="Attendees" IncludeAllColumns="false">
  <SyncColumns>
  <SyncColumn Name="Id" GlobalName="Id" IsPrimaryKey="true" IsNullable="false" SqlType="uniqueidentifier" />
    
  <SyncColumn Name="UserFirstName" GlobalName="UserFirstName" SqlType="varchar" />
    
  <SyncColumn Name="UserLastName" GlobalName="UserLastName" SqlType="varchar" />
    
  </SyncColumns>
    
 </SyncTable> 
 </SyncTables>

    Please refer to the chapter "SyncSvc Util Documentation / Server Scope Provisioning" in the SyncFX 3.0 CTP help file for a complete schema and description.

    Also, I'm having trouble understanding what [side] is.  Is that a schema?

    FilterClause="[side].UserID = @UserID" >

    This is an alias used in the sync related stored procedures added during provisioning the database. These procedures are based on this pattern:

    ... FROM [MainTable] [base] RIGHT JOIN [MainTable_tracking] [side] ...

    Please refer to the procedure Tag_selectchanges from the listdb sample.

    HTH

    • Edited by M.Bi Wednesday, July 7, 2010 6:43 AM Formatting fix
    • Marked as answer by mjayaram Monday, July 12, 2010 4:53 AM
    Wednesday, July 7, 2010 6:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    going through the test phase before we could release this as a hotfix. ETA is early next week.

    Any news on the hotfix, please?
    Thursday, July 8, 2010 2:37 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I don't know but I think they are trying to fix both issues with the syncUtil. The problem with the bit cols and this bug related to reading out the xml.
    Friday, July 9, 2010 1:11 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    That is right. We ran in to some unexpected delays. The hotfix should be out by EOD tuesday.
    Maheshwar Jayaraman - http://blogs.msdn.com/mahjayar
    Monday, July 12, 2010 4:46 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    where can i find this hotfix?

    Thursday, October 3, 2013 1:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    there is no hotfix issued for the Sync Toolkit. If it's not in the final code that was released, then its not there. you'll have to change/fix it yourself.
    Thursday, October 3, 2013 1:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The hotfix should be out by EOD tuesday.

    The hotfix was already finished but not released, really?

    Tuesday, October 8, 2013 4:16 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    the toolkit is not a fully released product where they release hotfixes for it. It's released as source code. When they say the hotfix is going to be released, they meant they're going to update the source code, not releasing a specific set of files to patch it.
    Wednesday, October 9, 2013 1:26 AM