I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database.
for some reasons I keep the old data in the databse and set a flag deactivated = 1
In a filter i download only deactivated = 0 - rows
The core-data I'm talking about are 6 tables, with each hundred thousands of rows, where about 30000 thousand are sent to the handhelds duing syncing.
The .OUT-File in the MS SQL CE-folder on the server has about 10 MB (!)
On syncining via gprs I receive this error: SQL CE error 28562 - Failed to create the Delete message to send to the Server
any ideas how to handle this problem?
Mobile DB: SQL Server CE 3.1 SQL Server 2008 R2