sql server compact vs sql server express
Posted on 2007-11-27
I currently have a program that uses SQL Server Express. Other than the pain it causes when my users have to install SQL Server Express, it works fine.
I noticed that SQL Server Compact only requires about 6 or so dll's that can be placed in my installation package.
So, my questions are:
- are there any reasons I should stick with Express?
- can the converstion from Express to Compact be done programmatically to make it painless?
- does Compact support networking?
- where can I find out more about Compact?
Thanks in advance...