I am syncing data from SQL server 2008 to SQL server compact edition (in a WinCE device).
While doing sync (in batches) i am getting the following error
{System.ServiceModel.CommunicationException: The maximum message size quota for incoming messages (29000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. ---> System.ServiceModel.QuotaExceededException:
The maximum message size quota for incoming messages (29000000) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.
On Increasing the MaxReceivedMessageSize to max, I start getting
{System.OutOfMemoryException: The buffer manager failed to allocate a buffer of 33873314 bytes. ---> System.OutOfMemoryException: OutOfMemoryException
I saw this thread.
http://social.microsoft.com/Forums/is/syncdevdiscussions/thread/2e1968fa-4dbe-47de-9f05-51f6e6d107f4
On following this, when I try to regenerate the client proxy code I get errors.
NetCFSvcUtil.exe http://com/TestSS/SyncService.svc
Microsoft (R) .NET Compact Framework Service Model Metadata Tool
[Microsoft (R) Windows (R) Communication Foundation, Version 3.5.0.0]
Copyright (c) Microsoft Corporation. All rights reserved.
Attempting to download metadata from 'http://com/TestSS/SyncService.svc' using WS-Metadata Exchange or DISCO.
Error: An error occurred in the tool.
Error: Error in the application.
Please help