This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Inserts on local database (SQL CE) not being pushed to SQL Server 2008 for Upload Only Sync

Question
0

Sign in to vote

Hi There,

I have a WPF Application that contains a local SQL CE database that is used on conjunction with the Sync Framework 2.1 and an SQL Server 2008 database.

I have provisioned the local and remote databases with a few different scopes for upload, download and bidirectional syncs.

My problem is that after inserting numerous rows on the client and hitting the upload only sync, nothing is uploaded and no apply change failed events fire, meaning that the changes are simply not being picked up.

To confuse matters this was working, and has now stopped. A clean install of the application also gives the same results.

Does anyone have any ideas as to how I can get some more information on what could be going wrong and why the changes are not being picked up?

Thanks!

Thursday, December 23, 2010 2:08 PM

Answers

0

Sign in to vote
You can enable sync trace to see whether the changes are enumerated in the upload sync or applied to the server by enabling trace in yourProgram.exe.config, see details at http://msdn.microsoft.com/en-us/library/cc807160.aspx

you could also check whether the changes falls into the scope you are syncing, can them be filtered out or are they in the scope you are syncing?
- Proposed as answer by jigu2014Microsoft employee, Editor Saturday, January 1, 2011 12:46 AM
- Marked as answer by jigu2014Microsoft employee, Editor Wednesday, January 5, 2011 7:10 PM
Monday, December 27, 2010 6:46 PM

Answerer