We help IT Professionals succeed at work.

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.
Comment
Watch Question

Top Expert 2011
Commented:
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.

Author

Commented:
Using Installshield 2013 Professional at the moment.

Author

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.

Author

Commented:
Thank you. I think this will work.