Click here to Skip to main content
15,504,549 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: 32 bit apps accessing > 4 gig? Pin
Electron Shepherd7-Jul-10 6:53
Electron Shepherd7-Jul-10 6:53 
GeneralRe: 32 bit apps accessing > 4 gig? Pin
Mladen Janković7-Jul-10 7:53
Mladen Janković7-Jul-10 7:53 
GeneralRe: 32 bit apps accessing > 4 gig? Pin
AspDotNetDev7-Jul-10 11:09
protectorAspDotNetDev7-Jul-10 11:09 
GeneralMicrosoft Gone Wild Pin
jpeterson7-Jul-10 6:26
jpeterson7-Jul-10 6:26 
GeneralRe: Microsoft Gone Wild Pin
Simon P Stevens7-Jul-10 6:43
Simon P Stevens7-Jul-10 6:43 
GeneralRe: Microsoft Gone Wild Pin
jpeterson7-Jul-10 7:40
jpeterson7-Jul-10 7:40 
GeneralRe: Microsoft Gone Wild Pin
Gary Wheeler8-Jul-10 3:49
Gary Wheeler8-Jul-10 3:49 
GeneralRe: Microsoft Gone Wild Pin
Yortw8-Jul-10 12:51
Yortw8-Jul-10 12:51 
Yeah, agreed. Also, don't believe the hype about compatiblity between one and the other. They are semi-compatible, and probably going up from Sql CE to Server Server (or Express) is possible, the reverse really isn't.

For example, MS claim the query syntax is the same... technically they are correct, but most Sql Server queries won't run in the Sql CE engine (especially if they were generated by some tool). Sql CE (when last I looked) had no concept of schema's or owners, so anything prefixed with dbo. (or any other schema/owner) failed to start with. There's also significantly less options when creating indexes etc (which is to be expected in the lighter weight engine) and there are data types missing (again, when I last looked, varchar wasn't supported, only nvarchar). That means most create table statements that are created by scripting existing tables from Sql Server databases won't work in Sql CE either.

Then there's differences between the existing data types. Max nvarchar size in Sql CE is 4000 characters, so if you have large varchars in your tables and you just try to converting them to nvarchar to make your app run in Sql CE you'll run into other problems down the line.

Also, performance can be a problem. Sql CE is very quick at what it does, but is has (or at least didn't have) any in RAM cache for the data so if you're running it off a slow disk then the performance for some queries will suck and will suck every time they are run (we wanted to use it in an embedded system with flash based storage, but for the size of data we were working with some queries just didn't perform like we needed).

Finally, Sql CE is file based so it's great as a local database, but if you want it hosted on another server or to access it from local clients it's not really a great fit.

Of course, if you start out using Sql CE from the beginning and it fits your use-case then it's a great tool to have. I guess my point is that there seems like a lot of overlap, and there sort of is in a bullet point list of features, but they are really the same at all. So I agree with Simon.
GeneralRe: Microsoft Gone Wild Pin
QuiJohn7-Jul-10 7:45
QuiJohn7-Jul-10 7:45 
GeneralRe: Microsoft Gone Wild Pin
Joe Woodbury7-Jul-10 8:41
professionalJoe Woodbury7-Jul-10 8:41 
GeneralRe: Microsoft Gone Wild Pin
Phil Martin7-Jul-10 12:35
professionalPhil Martin7-Jul-10 12:35 
GeneralRe: Microsoft Gone Wild Pin
erictehmick8-Jul-10 4:15
erictehmick8-Jul-10 4:15 
GeneralRe: Microsoft Gone Wild Pin
rcampbell128-Jul-10 6:11
rcampbell128-Jul-10 6:11 
GeneralRe: Microsoft Gone Wild Pin
JasonPSage8-Jul-10 7:25
JasonPSage8-Jul-10 7:25 
GeneralRe: Microsoft Gone Wild Pin
Sandeep Datta9-Jul-10 2:03
Sandeep Datta9-Jul-10 2:03 
GeneralRe: Microsoft Gone Wild Pin
El Corazon7-Jul-10 8:32
El Corazon7-Jul-10 8:32 
GeneralRe: Microsoft Gone Wild Pin
QuiJohn7-Jul-10 8:44
QuiJohn7-Jul-10 8:44 
GeneralRe: Microsoft Gone Wild Pin
El Corazon7-Jul-10 8:56
El Corazon7-Jul-10 8:56 
GeneralRe: Microsoft Gone Wild Pin
lepipele8-Jul-10 6:04
lepipele8-Jul-10 6:04 
GeneralRe: Microsoft Gone Wild Pin
keozcigisoft8-Jul-10 7:14
keozcigisoft8-Jul-10 7:14 
GeneralRe: Microsoft Gone Wild Pin
Mark J. Miller8-Jul-10 8:57
Mark J. Miller8-Jul-10 8:57 
GeneralRe: Microsoft Gone Wild Pin
mathomp38-Jul-10 10:57
mathomp38-Jul-10 10:57 
GeneralCode Project Happy 10thYear one day late Pin
ProfessorDan7-Jul-10 5:57
ProfessorDan7-Jul-10 5:57 
GeneralRe: Code Project Happy 10thYear one day late Pin
Smithers-Jones7-Jul-10 6:03
Smithers-Jones7-Jul-10 6:03 
GeneralRe: Code Project Happy 10thYear one day late Pin
ProfessorDan7-Jul-10 6:28
ProfessorDan7-Jul-10 6:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

How would you describe your current job?
Fighting dragons everyday or clicking the same boxes on the same forms, day after day?
  Results   410 votes