• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1024
  • Last Modified:

Best Database for Vb.Net Application

Hi,

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.

Stuart
0
StuartK
Asked:
StuartK
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.

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

http://www.microsoft.com/sql/editions/express/redistregister.mspx
0
 
StuartKAuthor Commented:
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
VBRocksCommented:
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.

0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>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.
0
 
StuartKAuthor Commented:
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?

Stuart
0
 
VBRocksCommented:
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.



0
 
StuartKAuthor Commented:
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.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now