Best Database for Vb.Net Application

Posted on 2007-10-16
Last Modified: 2013-12-25

We have a 150+ form, 300,000 line VB.Net application that currently connects to Microsoft Access 2003.

We want to change to another Database (Sql Server, MySql, or any other recommendations)

Any recommendations?? We ideally want royality free distribution, but we are aware that MySql require it.

Question by:StuartK
    LVL 65

    Assisted Solution

    by:Jim Horn
    Is this app desktop only, distributed to remote users, networked within a company that has a set image?
    Does data need to synchronize to a 'master' database?
    Are there any security issues, such as credit card numbers, social security numbers, ?

    These Q's are not exclusive of anything else you'd need to factor in.
    You'll need to answer these before we can recommend a specific product.

    LVL 21

    Assisted Solution

    Sql Server Express 2005 is more or less free to distribute and compatible with the full version of Sql Server:

    Author Comment

    Hi Jim,

    It is Desktop software developed with Windows Forms. We offer two types, a single user version and network version, but clients within the the company premises.

    Our database resides on the nominated Server, and all clients interact with that server over the network.

    The Database is for a company monitoring and maintaining Alarms Systems for customers (domestic as well as Business premises)

    The database hold information about what System each customer has installed at various locations. Therefore there are passwords etc. that need to be protected from hacking. Also the software maintains service contracts etc, so there will be various Bank Details etc. Obviously, for these reasons, the database has to be secure to protect burglary of these premises.

    Any thoughts??

    mastoo : Thanks for info on Sql Server Express! One we are considering at the moment.
    LVL 27

    Accepted Solution

    Ditto on SQL Express!

    SQL Server Express is free!  It has a 4 GB capacity, and supports standard tables, views and stored
    procedures.  Coming from an Access background, I was originally intimidated by "SQL SERVER", so it
    took me a bit before I really started moving in the direction.  However, once I did, I found it is very easy
    to use!  

    Additionally, if you have VS2005 Professional, then SQL Server developer addition comes with it, and it
    has no limitation on storage capacity.

    VB.NET has optimized Classes to work with SQL (SQLClient namespace), making transactions faster
    than JET 4.0 (Access' DB Engine).

    My preference is VB.NET Windows front end, and a SQL backend.

    LVL 65

    Expert Comment

    by:Jim Horn
    >monitoring and maintaining Alarms Systems for customers
    This should rule out Access, as Access does not have native database maintenance functions that work to keep the app up 24/7.

    >so there will be various Bank Details etc.
    Same as above, for bank info security reasons.

    Regarding SQL vs. SQL Express, I'll step back and let the above experts comment, as I'm not intimately familar with making design choices between the two.

    Author Comment

    VBRocks, great answer. Really informative! thank you

    It's Visual Studio 2005 Professional we are using, so I guess what your saying is Sql Server developer package comes with it.

    Can we therefore distribute this database onto our cusotmers computers without any licensing costs as part of our end product installation? (The intention is Vb.Net front end and database backend embedded with the installation package (i.e. there is no user interaction with sql server))

    Any other limitations you can see that we have overlooked?

    LVL 27

    Expert Comment

    You can develop your database in SQL Server developer addition and deploy it with your program,
    however, you cannot install the SQL Server developer addition on the client pc, you will have to install
    SQL Server Express on the client's computer, and then attach your database to it.  It's pretty simple.


    Author Comment

    How rude of me for not allocating points.

    Guess because this was a question of debate, and therefore never really came to a conclusion with my boss, so I guess I kept the question open just in case I needed to ask any more questions. Therefore, time has passed, and here we are now. Good news is, on reflection we have made a discision!

    We have in the background kind of descided to go with SQL express. You comments have guided us to our final conclusion, and I thank every one of you for entering the debate.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now