We help IT Professionals succeed at work.
Get Started

Deployable SQL Server Replacement for Access Drivers for VB.Net database Front-End Application

148 Views
Last Modified: 2015-04-07
I have an application that provides built in Access drivers for use in a VB.Net 2010 database front-end application. It also provide SQL Server 2005-2008 R2 if the user has this database platform. The reason we use Access is so that users have a simple way to test and even use the application without having to have SQL Server or have the ability to set-up a SQL Server. The application may be downloaded and tested by potential users and the Access option is available and completely pre-configured for this purpose.

The question I have is what would be a suitable SQL Server replacement that could be installed and configured easily without the user having to understand SQL Server so that users could test the application with little difficulty. We are aware of SQL Server Express but this still requires an experienced user to set this up as far as I know. SQL Compact is virtually useless because it does not support stored procedures or Views. The application dataabse has approximately 300 table, 600 views and 1800 stored procedures. Trying to maintain an Acces and a SQL Server version of this with the same application code is no longer feasible. Any ideas or direction on this would be greatly appreciated.
Comment
Watch Question
CERTIFIED EXPERT
Top Expert 2011
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE