Selecting a Perfect Database

Question

0.00/5 (No votes)

See more:

Hi Experts,

I've been working on diff. kind of databases from some time. My software is developed in VB.Net with backend as MS-Access. This was the scenario when I had few modules and very little job and even little client. So I never opted for Atomicity and other facilities that Oracle MS-Sql give and access don't. I selected MS-Access suitable for me as I can distribute it free with MS Jet Ole Db dll. Right ?

But Now since modules are getting increased, working on the software is being enhanced. So I have to think for some Sql Server, Sql Lite or may be oracle. So I am on the stage to enhance the tech.

Can you suggest me what will be the best option of Databases available for me ? If I like to distribute it tension free. What I should adopt.

I know several datasets or queries have been created in access format like using iif in query and few like that. I have also need to change them.

There are basically two questions:

1. What will the best suitable database for me (I like to have atomicity and sql command in a flow) Free will have a priority ? and I dont like someone to see my database structure as it is designed cleverly and not being found in this industry yet?

2. I will not migrate the software entirely, I will give new kind of database only to those who have big database or purchasing more modules from me ? Should I separate the code for both the databases ?

Please suggest me asap.

Thanks & Best Regards

Jay Khatri

Posted 15-Oct-10 2:18am

JayKhatri

Add a Solution

3 solutions

Solution 2

Thank you very much steve, I am fully agree with ur suggestion.

Can you answer my second question also.

Thanks & Best Regards

Jay Khatri

Posted 15-Oct-10 8:35am

JayKhatri

Solution 3

and if sql server express edition is free then why to stick with access. Should I leave access entirely.

Thanks & Best Regards

Jay Khatri

Posted 15-Oct-10 8:52am

JayKhatri

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)

Steve Maier · Accepted Answer · 2010-10-15T08:09:00

SQL Server Express would work for you, but that has to be installed on the machine or a server for people to use. Another micrsoft option would be SQL Compact Edition. It is alot like Access because it is a single file, but gives more of a SQL Server feel for it and the commands it uses. Both of these are free. CE has the issue that you cannot have stored procedures but most everything else is the same as SQL Server.

Both Express and CE can handle up to 4G of data and the newest SQL Express 2008 R2 can handle 10G all for free.

Selecting a Perfect Database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us