locked
How to delete table tracking data and scope_config,scope_info after synchonization is done? RRS feed

  • Question

  • i synced Sql express and remote sqlserver 2005 using WCF,for each table - tracking table is created and also for all table one scope_info,one scope_config tables are created.

    since this data goes on increases which is least important after sync,i wan to delete once sync is done.

    How to do that?

     

     

     

    Wednesday, April 7, 2010 6:06 AM

All replies

  • SyncFx SDK doesn't expose an API to modify/delete scope definition as well as dropping the scope tables and the corresponding triggers/stored procedures that maintain the metadata.

    So if you want to drop those objects, you'll have to do it manually.

    instead of dropping the sync objects, you may want to do periodic metadata clean up instead. See http://msdn.microsoft.com/en-us/library/ee617373(SQL.105).aspx

    • Edited by JuneT Sunday, April 11, 2010 1:06 PM
    • Proposed as answer by JuneT Tuesday, April 13, 2010 11:43 AM
    Wednesday, April 7, 2010 8:50 AM
  • Thanks for reply.it is helpful.
    Wednesday, April 7, 2010 10:10 AM