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

avatar image

770 36 41 45

(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

avatar image

15.6k 22 57 38

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

avatar image

1.7k 12 16 21

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Sep 18, 2012 at 03:27 PM

Seen: 6043 times

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

Copyright 2018 Redgate Software. Privacy Policy