Bulk apply procedures not supporting with SQL server2005
-
25 czerwca 2012 14:48
At the first phase of our development we were having sync service with SQL server 2008 db which is provisoned with SyncSVC util. I have provisioned the database with bulk Apply procedures enabled. At a later stage we have one client who have only SQL server 2005 db.I got an answer from this forum saying sql server 2005 sp2 is compatible with sync service.(http://social.msdn.microsoft.com/Forums/nl-NL/synclab/thread/7556e4e7-5223-4fc5-9e6d-fed63b9b5afc).
So while provisoning this database with bulk apply procedure i get an exception saying bulktype is not supported in sql 2005.so i have disabled that option in config file and reprovisioned the 2005 db. worked perfectly. download changes as well as upload changes too work good.
so my questions are:
1) can i remove the bulk apply procedures from 2008 database?
2)what is the purpose of bulk apply procedures?.By removing it does it impact the working of sync services?
Any help would be appreciated.
Wszystkie odpowiedzi
-
26 czerwca 2012 01:19Moderator
if you're provisioning via the API, it should detect if you're using SQL 2008 and will enable the bulk procedures by default and for SQL 2005 it will not.
The bulk procedures saves you roundtrips to the database by sending the changes once and applying it using the MERGE statement. without the bulk procedures, sync fx will send the changes row by row. for example, if you have a 100-row insert, it will send 100 insert statements compared to one using the bulk procedures.
you can disable using bulk procedures in SQL 2008 by setting the SetUseBulkProceduresDefault value during provisioning.
- Oznaczony jako odpowiedź przez b_abrams 26 czerwca 2012 05:23
-
26 czerwca 2012 05:23Thanks June.. It is clear now.
