Hi all;
Just yesterday, project management of the application i am working on decided to change the DB we had been using. We had been using an Sqlite DB and are now moving to using Sql Express 2014. As one of my jobs on the project i am also responsible for doing the application's installer. Our application is web based with a number of web services. I am looking at using the Sql Express 2014 LocalDB install as it is a quiet, easier install that the full blown Sql express install and we really only need the localdb functionality. I can see how to create the Named Instance. Once that is done we are looking at generating the db from a set of Sql Scripts.
My question is: Once i have installed the Sql Express2014 LocalDB and used SqlLocalDb to create the Named Instance, how do i connect to it and run the Sql scripts to setup the database? Is there a tool that comes with it?

Shawn

Go to the complete details ...