I would like to provide along with my application, a simple SQL Server database which would be easily installable, via an installer, on even a virgin machine. (1)How would that work? Right now I am looking at either using a SQL Server compact db or the SQL Server Express Local DB. More likely the Local DB option.
(2)Is there any better way of doing this?
(3)With the localDB option, once the end user runs the install for the localDB, what is the standard way of installing all the db objects needed for him to use the app?
(4)What are the local DBs limitations?