I'm using CE 3.5 in a Windows form application. My ServerSyncProvider includes a list of columns, to use on the client, for each table.
To add a column, I first add the column on the server and then add the column name to the list for that table in my ServerSyncProvider. The synch fails because, I assume, the column list does not match the client schema. To get around this I've been deleting
the client DB and starting with a fresh synch. The problem is I lose data if the client DB has not been sync'd prior to the DB deletion.
How can I make a schema change, adding a column, on the client while preserving the data?
I've thought about creating 2 different ServerSyncProviders. I would first sync with the old (saving the data) and then deleting the client db and syncing again with a new ServerSyncProvider (including the new column). I'm hoping there is a more elegant
solution
Thanks!
