SQL server express to Compact

Question

0.00/5 (No votes)

See more:

Hai ...
I have completed a windows application project with DB with sqlsever express. My Project consisting of 2 crystal reports too.. But installing the SQL sever express to many clients is a tedious task for them .So I want to change my DB to SQL Server COMPACT edition.
My question is
"Whether all queries and condition will also work in Compact DB. And
Whether Changing from from SQL EXPRESS to COMPACT will be fruitful ???or Is there any idea to build my application light weight???

Posted 21-Jul-11 20:11pm

JaisonRose

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-07-21T21:21:00

It depends on a couple of things.
1) Do you use stored procedures? If you do, then be aware that SqlCE does not support them.
2) Do you chain commands? Again, not supported.
3) Do you need multiuser access? Just about possible, but really not a good idea with SQLCE - it will give you serious grief.
4) Do you need backups? If so, then you are probably better off with SQl Server, because backing up is intrusive on CE - while teh backup is taking place, no other activity can occur.

Other than that, there is a list of differences here: MSDN[^]

Mycroft Holmes · Answer 2 · 2011-07-21T21:21:00

Solution 2

This link [^] may be useful - a simple google search found it!

A major issue may be that stored procedures are not available in Compact

Posted 21-Jul-11 21:21pm

Mycroft Holmes

Comments

[no name] 22-Jul-11 3:25am

Excellent.+5.