which type of database should I choose and why?

Question

0.00/5 (No votes)

See more:

, +

Hey guys, happy Xmas etc.
I have a question: which type of db should I choose and why?

When I add/create a database to my VB.net 2010 project I am offered a couple choices; sql ce and SQL server. I'm never sure which one I should be choosing, I've tried both of them but they seem to differ in the way they can be built. For example the screens look a bit different when editing the db tables and the way to
modify key fields and relationship fields is different.

I find it very confusing, but I don't know which one is best for me. I'm thinking SQL-CE is for desktop, and SQL-server is for the net right or wrong?

So which Horse for what course??

appreciate your input

Posted 25-Dec-11 9:54am

It is what it is

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)

**Dalek Dave** · Answer 1 · 2011-12-25T09:58:00

Solution 1

Better off with server, it has more functionality.
The Compact Edition still works but with less width of control.

It ultimately depends on your needs and preferences, but SQL Server is a standard box of tricks that people are familiar with, so legacy wise it is better.

Posted 25-Dec-11 9:58am

Dalek Dave

**AmitGajjar** · Answer 2 · 2011-12-25T18:40:00

Solution 2

Hi,

why don't you check for MySQL,

here is the proof why MySQL vs MsSQL?

never used SQL-CE so no more idea about that.

hope above article will help you,

thanks
-amit.

Posted 25-Dec-11 18:40pm

AmitGajjar