I have a question please?
In my company they decide to design a program to insert some data so we use asp as an interface. but with database is the problem..this program will install on 1200 pcs locally.and they don't want to install SQL server on these pcs ..the company decide if there is no other solution to use access 2007 as database and asp.net as interface(but I don't like access. can we attached the file data with web application and work on it without install SQL Server....
I heard there is a compact SQL to this work....is this right ?Any idea any suggestion ? plz
asked Sep 18, 2012 at 03:27 PM in Default
You have several options, depending on what you are trying to do. The first thing to ask is: Do you want each of these 1200 pcs to have their own instance of the database? Very frequently each PC will have its own instance of the client software, but that client software will connect to one (or a few interconnected) servers that run SQL Server and manager the databases.
If you want each one to have its own database, then SQL Server Express is probably what you want. SQL Server Express is a light weight, generally free (as in without cost, not open source) version of SQL Server that is meant to run on a desktop. It is great for study, light testing, or to serve as the backend for local applications. There are a couple of different versions of SQL Server Express and localDB is a light version of express that runs in user space. It seems to be exactly what you want.
Just for the sake of being comprehensive, I'll add that SQLite is another light weight database management system designed to run in user space and generally meant to support single user applications. I generally prefer SQL Server Express, but it is good to have options.
answered Sep 18, 2012 at 04:58 PM
As an addition to @TimothyAWiseman's answer, this is a nice comparison of SQL Express, localdb and Compact Edition: http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx
answered Jun 19, 2013 at 08:46 PM