Number of syncs per connection in SQLCE -> SqlServer session RRS feed

  • Question

  • How many (table) syncs can be run per SQLConnection? IOW, can I sync more than one table on any given SQLConnection?
    Monday, October 1, 2012 7:34 PM

All replies

  • you can sync more than one table.
    Tuesday, October 2, 2012 1:29 AM
  • How many more??? Could I do 30 tables? If I do that many, should I use ONE connection, or should each have it's own connection? Problem I am having is, when I sync more than 20 or so, When my app tries to do a sql operation via c++-ADO, I get connection problems.


    • Edited by SteveInHouston Tuesday, October 2, 2012 12:09 PM spell check
    Tuesday, October 2, 2012 11:40 AM
  • if you're getting an error, then its most likely a concurrency problem. you will get that if you have multiple processes accessing the same database regardless of whether you use sync framework or not.

    you could a hundred tables in a sync group or a sync scope if you want, but that doesnt open up a hundred connections at the same time. each table will be synched one at a time, not concurrent.

    Wednesday, October 3, 2012 2:00 AM