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

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.
gcook17Asked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
What are you using to create your installer/deployment package?

I have been looking into InstallAware to make SQL Server deployment very simple.

InstallAware First and Only Installation Toolkit to Support SQL Server Express 2012 (Denali) Installation

Free update for InstallAware 2012 provides one-click installation for Microsoft’s newly released SQL Server Express 2012 (Denali), including support for 32 bit and 64 bit versions.
0
 
ste5anSenior DeveloperCommented:
0
 
gcook17Author Commented:
Using Installshield 2013 Professional at the moment.
0
 
gcook17Author Commented:
We are looking at the SQL Server 2014 LocalDB at the moment and may respond with additional questions regarding this proposed solution. Thank you.
0
 
gcook17Author Commented:
Thank you. I think this will work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.