Finished!

Well, I've finally successfully finished upgrading everything to SQL CE, with only a few other hiccups. 1 was the fact that SELECT TOP ? PERCENT doesn't work, although SELECT TOP does. In the end, that's not too big of a deal for me. The other was a little more difficult to figure out.

Our intent is to send our product with the SQL CE database included in the install. We need to be able to support 2 types of users, those who will be synchronizing with a server, and those who will not. I created the base compact database using synchronization, and delteted the subscription inside it, thinking that if the user was going to decide during installation to connect to the server, that the subscription could be re-created. This didn't seem to be the case. I kept getting 'this database is not configured for replciation' errors when i tried to create a subscription through code. Plus, a database that is synchronized to one database cannot have it's subscription changed to point to another database.

Because of that, I believe i will have to package separate databases with our installation, and let the installer choose which one to make active (getting rid of the other ones after install). Unless there's a better way out there, this seems to work well enough for me for right now.