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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.