Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
    
Duplicate stackoverflow.com/questions/15826998/merge-replication-too-big better to migrate it –  Remus Rusanu Apr 5 '13 at 6:55
    
Do you really need all this data on the device? –  ErikEJ Apr 5 '13 at 8:41
    
Well I don't know which data i need excatcly, but it can be all of the data in this pool. And it has to work also without internet-connection, that's the reason why I use replication. –  Karl Apr 10 '13 at 9:05
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.