I am using Microsoft Pro Sync Franework to synchronize a SQL Server CE 3.5 database with SQL Server 2008 R2 Express. I have a few question:
I know how to encrypt the connection string in app.config. How do I decrypt it on the server side so it is not transmitted in plain text?
The database is relatively small. How would I programmatically encrypt the entire db on both computers and then maintain synchronization? It would not work well if the encryption depended on the user/machine combination. I would need to use a machine independent method.