CODEWITHSUNDEEP
sqlsql-server-cesql-server-express
user1895399
user1895399

Reputation: 147

Move from SQL Server CE to SQL Server Express

I just wrote a large program using SQL Server Express and was very happy, the difficulty is that it is difficult for customers to install SQL Server to test the program out.

I looked into SQL Server CE and it looks great for smaller clients and trial software. However SQL Server CE uses System.Data.SqlCeServer and not System.Data.SqlClient

Is there a way to make an application that uses SQL Server CE and then if desired the client can upgrade to SQL Server Express?

Upvotes: 2

Views: 159

Answers (1)

Beth
Beth

Reputation: 9607

No, they're different platforms. CE is for the Compact Edition, so it's intended to be used on sometimes disconnected devices with limited resources compared to a SQL Server. CE should have a subset of Express' functions.

Upvotes: 2

Related Questions