x

Working on Database without install SQL Server

Dear all,

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
more ▼

asked Sep 18, 2012 at 03:27 PM in Default

Troy_2012 gravatar image

Troy_2012
750 26 37 39

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Sep 18, 2012 at 04:58 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.6k 21 23 32

Thanks TimothyAWiseman ,

I'm going to use SQLite.
Sep 18, 2012 at 05:44 PM Troy_2012
It is a very good option. I have used it for several projects and been very happy with it.
Sep 18, 2012 at 08:12 PM TimothyAWiseman

And another good option could be Firebird Embeded. When deploying it is a single Dll which is going with your application without any additional installation.

Jun 20, 2013 at 05:06 AM Pavel Pawlowski
(comments are locked)
10|1200 characters needed characters left
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
more ▼

answered Jun 19, 2013 at 08:46 PM

tomgough79 gravatar image

tomgough79
1.7k 11 14 16

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1850
x68

asked: Sep 18, 2012 at 03:27 PM

Seen: 1764 times

Last Updated: Jun 20, 2013 at 05:06 AM